This repository has been archived by the owner on Nov 9, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
JAG.txt
28 lines (27 loc) · 2.1 KB
/
JAG.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
CREATE TABLE CUST (CNO CHAR(6), CNAME CHAR(50), CITY CHAR(50));
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CONE', 'JEA', 'Jacksonville');
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CTWO', 'DancingDragon', 'SanDiego');
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CTHREE', 'AMInc', 'NewYork');
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CFOUR', 'XYZOrganization', 'NewMexico');
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CFIVE', 'JEA', 'NewYork');
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CFIVE', 'DreamBig', 'Dallas');
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CTWO', 'FamousAmos', 'Jacksonville');
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CFOUR', 'XYZOrganization', 'Dallas');
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CFIVE', 'JEA', 'NewYork');
INSERT INTO CUST(CNO, CNAME, CITY) VALUES('CTWO', 'DreamBig', 'Dallas');
CREATE TABLE ORDERS(SNO CHAR(5), PNO CHAR(5), CNO CHAR(6), TTLQTY INT(6));
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('SONE', 'PONE', 'CONE', '10');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('SONE', 'PTHRE', 'CONE', '500');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('SONE', 'PTHRE', 'CTWO', '45');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('STWO', 'PTWO', 'CTHREE', '2');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('STWO', 'PONE', 'CTWO', '8');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('STWO', 'PONE', 'CFOUR', '1');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('STHRE', 'PFIVE', 'CFIVE', '60');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('STHRE', 'PFOUR', 'CONE', '87');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('STHRE', 'PSIX', 'CFOUR', '21');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('SFOUR', 'PFIVE', 'CFIVE', '8');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('SFOUR', 'PTWO', 'CTWO', '10');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('SFOUR', 'PTWO', 'CONE', '500');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('SFOUR', 'PONE', 'CFOUR', '6');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('SFOUR', 'PSIX', 'CFIVE', '2');
INSERT INTO ORDERS(SNO, PNO, CNO, TTLQTY) VALUES('SFOUR', 'PFOUR', 'CTWO', '9');