CREATE TABLE 1
COPY FROM 5
CREATE TABLE 1
COPY FROM 6
CREATE TABLE 1
COPY FROM 12
sno
---
S1 
S4 
SELECT 2
sno
---
S1 
S4 
SELECT 2
pno
---
P2 
P3 
P6 
SELECT 3
pno pname
--- -----
P5  Cam  
P6  Cog  
SELECT 2
sname
-----
Blake
Clark
Jones
Smith
SELECT 4
sname
-----
Clark
Jones
Smith
SELECT 3
sname
-----
Clark
Jones
Smith
SELECT 3
sname
-----
Blake
Clark
Jones
Smith
SELECT 4
sno
---
S1 
S2 
S3 
S4 
SELECT 4
sno
---
S1 
S2 
S3 
S4 
SELECT 4
pno
---
P1 
P2 
P3 
P5 
SELECT 4
pname
-----
Cog  
SELECT 1
sname
-----
Blake
Clark
Jones
Smith
SELECT 4
sname
-----
Adams
SELECT 1
sname
-----
Smith
SELECT 1
DROP TABLE 1
DROP TABLE 1
DROP TABLE 1
