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

 1/*
 2REM
 3REM q14.sql
 4REM
 5REM For each laptop made by manufacturer 'E', add one inch to
 6REM screen size and subtract $100 from the price.
 7REM
 8*/
 9
10\. set-db.sql
11
12UPDATE Laptop
13SET screen = screen + 1,
14    price = price - 100
15WHERE model IN (SELECT L.model
16                FROM Product P, Laptop L
17                WHERE P.model=L.model
18		  AND P.maker='E');