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

 1/*
 2REM
 3REM q12.sql
 4REM
 5REM Delete all shipments for suppliers in 'London'.
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "spj";
11
12DELETE FROM Shipments
13WHERE SN IN (SELECT SN 
14             FROM Suppliers
15             WHERE City = 'London');