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

 1/*
 2REM
 3REM q13.sql
 4REM
 5REM Delete all Laptops made by a manufacturer that doesn't make
 6REM printers.
 7REM
 8*/
 9
10\. set-db.sql
11
12DELETE FROM Product
13WHERE type='laptop'
14  AND maker NOT IN (SELECT maker
15		    FROM Product
16		    WHERE type='printer');
17
18DELETE FROM Laptop
19WHERE model NOT IN (SELECT model
20                    FROM Product);