SQL

Example Tables

CREATE TABLE SALESPEOPLE(SNUM NUMBER(5) PRIMARY KEY,  SNAME CHAR(10),  CITY CHAR(20),  COMM DECIMAL(8,3));

INSERT INTO SALESPEOPLE VALUES (1001, 'Peel', 'London',0.12); 
INSERT INTO SALESPEOPLE VALUES(1002, 'Serres','San Jose',0.13); 

CREATE TABLE CUST(CNUM NUMBER(5) PRIMARY KEY,  CNAME CHAR(20),  CITY CHAR(20), RATING NUMBER(3),SNUM NUMBER(4));

INSERT INTO CUST VALUES (2001, 'Hoffman', 'London',100,1001); 
INSERT INTO CUST VALUES (2002, 'Giovanne', 'Rome',200,1003); 
			

CREATE TABLE ORDERS(ONUM NUMBER(5) PRIMARY KEY,  AMT NUMBER(5,2), ODATE Date, CNUM NUMBER(4),SNUM NUMBER(4));

INSERT INTO ORDERS VALUES (3001,18.69,03-OCT-94,2008,1007); 
    INSERT INTO ORDERS VALUES (3003,767.19,031094,2001,1001);