CREATE TABLE 1
COPY FROM 5
CREATE TABLE 1
COPY FROM 6
CREATE TABLE 1
COPY FROM 12
n1
--
 5
SELECT 1
n2
--
 4
SELECT 1
n3
--
 4
SELECT 1
tot1
----
1000
SELECT 1
sno
---
S1 
S2 
S4 
SELECT 3
sno
---
S1 
S3 
S4 
S5 
SELECT 4
UPDATE 2
sno sname status city  
--- ----- ------ ------
S1  Smith     20 London
S2  Jones     20 Paris 
S3  Blake     60 Paris 
S4  Clark     20 London
S5  Adams     30 Athens
SELECT 5
UPDATE 3
pno pname color weight city  
--- ----- ----- ------ ------
P1  Nut   Red       12 Athens
P2  Bolt  Green     17 Paris 
P3  Screw Blue      17 Rome  
P4  Screw Red       14 Athens
P5  Cam   Blue      12 Paris 
P6  Cog   Red       19 Athens
SELECT 6
DELETE 4
pno pname color weight city  
--- ----- ----- ------ ------
P1  Nut   Red       12 Athens
P5  Cam   Blue      12 Paris 
SELECT 2
DROP TABLE 1
DROP TABLE 1
DROP TABLE 1
