Yurttas/PL/DBL/postgres/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
10SELECT current_schema();
11SET search_path to "pc";
12
13UPDATE Laptop
14SET screen = screen + 1,
15    price = price - 100
16WHERE model IN (SELECT L.model
17                FROM Product P, Laptop L
18                WHERE P.model=L.model
19		  AND P.maker='E');