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

 1/*
 2REM
 3REM q10.sql
 4REM
 5REM Set the shipment quantity to zero for all suppliers in 
 6REM 'Denver'.
 7*/
 8
 9SELECT current_schema();
10SET search_path to "spj";
11
12UPDATE Shipments
13SET quantity = 0
14WHERE sn IN (SELECT sn
15             FROM Suppliers
16             WHERE city = 'Denver');