Yurttas/PL/DBL/mssql/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
 9UPDATE Shipments
10SET quantity = 0
11WHERE sn IN (SELECT sn
12             FROM Suppliers
13             WHERE city = 'Denver');