Yurttas/PL/DBL/oracle/F/01/PC/q14.sql

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