Yurttas/PL/DBL/mssql/F/01/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
9DELETE FROM Product
10WHERE model IN (SELECT model
11 FROM PC
12 WHERE hd<2.0);
13
14DELETE FROM PC
15WHERE hd<2.0;