CREATE TABLE 1
COPY FROM 5
CREATE TABLE 1
COPY FROM 6
CREATE TABLE 1
COPY FROM 12
xx yy
-- --
S1 S4
S2 S3
SELECT 2
      aq   sq
-------- ----
258.3333 3100
SELECT 1
pno pqty
--- ----
P1   600
P2  1000
P3   400
P4   500
P5   500
P6   100
SELECT 6
pno
---
P1 
P2 
P3 
P4 
P5 
P6 
SELECT 6
sno
---
S3 
SELECT 1
sno pno
--- ---
S1  P1 
S1  P4 
S1  P6 
S2  P2 
S2  P5 
S3  P2 
S3  P5 
S4  P1 
S4  P4 
S4  P6 
SELECT 10
sno pno
--- ---
S2  P1 
S2  P4 
S2  P6 
S3  P1 
S3  P4 
S3  P6 
SELECT 6
sno pno
--- ---
S2  P2 
S2  P5 
S3  P2 
S3  P5 
SELECT 4
scity  pcity 
------ ------
London London
London Paris 
London Rome  
Paris  London
Paris  Paris 
SELECT 5
xx yy
-- --
S1 S1
S1 S4
S2 S2
S2 S3
S3 S2
S3 S3
S4 S1
S4 S4
S5 S5
SELECT 9
pno xxx yyy
--- --- ---
P1  300 300
P2  400 200
P4  300 300
P5  400 400
SELECT 4
pno
---
P1 
P2 
P4 
P5 
SELECT 4
pno text1             gmwt color text2          mqy
--- ----------------- ---- ----- -------------- ---
P1  Weight in grams = 5448 Red   Max quantity = 300
P3  Weight in grams = 7718 Blue  Max quantity = 400
P5  Weight in grams = 5448 Blue  Max quantity = 400
SELECT 3
sno sname status city   pct apct
--- ----- ------ ------ --- ----
S1  Smith     20 London   6  4.5
S2  Jones     10 Paris    2  1.5
SELECT 2
pno xxx yyy
--- --- ---
P1  300 300
P2  400 200
P4  300 200
P5  400 100
SELECT 4
pno
---
P1 
P2 
P4 
P5 
SELECT 4
xx yy
-- --
S1 S1
S1 S4
S2 S2
S2 S3
S3 S2
S3 S3
S4 S1
S4 S4
S5 S5
SELECT 9
pno xxx yyy
--- --- ---
P1  300 300
P2  400 200
P4  300 200
P5  400 100
SELECT 4
DROP TABLE 1
DROP TABLE 1
DROP TABLE 1
