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');