Yurttas/PL/DBL/mysql/F/01/00/PC/q12.sql

 1/*
 2REM
 3REM q12.sql
 4REM
 5REM Delete all PC's with less than 2 gigabyte of hard disk.
 6REM
 7*/
 8
 9\. set-db.sql
10
11DELETE FROM Product
12WHERE model IN (SELECT model
13		FROM PC
14                WHERE hd<2.0);
15
16DELETE FROM PC
17WHERE hd<2.0;