Yurttas/PL/DBL/mysql/F/01/00/SPJ/q10.sql

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