Yurttas/PL/DBL/oracle/F/01/PC/q10.sql
1REM
2REM q10.sql
3REM
4REM Find the maker of the printer with the fastest processor
5REM among all those PC's that have the smallest amount of RAM.
6REM
7
8CREATE VIEW SmallRam(model,ram)
9 AS (SELECT model, ram
10 FROM PC
11 WHERE ram IN (SELECT MIN(ram)
12 FROM PC));
13
14SELECT P.maker
15FROM Product P, PC C, SmallRam S
16WHERE P.model=C.model
17 AND C.model=S.model
18 AND C.speed IN (SELECT MAX(speed)
19 FROM PC, SmallRam S
20 WHERE PC.model= S.model);