Yurttas/PL/DBL/mssql/F/01/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
10UPDATE Laptop
11SET screen = screen + 1,
12    price = price - 100
13WHERE model IN (SELECT L.model
14                FROM Product P, Laptop L
15                WHERE P.model=L.model
16		  AND P.maker='E');