Yurttas/PL/DBL/oracle/F/01/SPJ/q12.sql

 1REM
 2REM q12.sql
 3REM
 4REM Delete all shipments for suppliers in 'London'.
 5REM
 6
 7DELETE FROM Shipments
 8WHERE SN IN (SELECT SN 
 9             FROM Suppliers
10             WHERE City = 'London');