Yurttas/PL/DBL/oracle/F/01/SPJ/q07.sql

From ZCubes Wiki
Revision as of 23:13, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div"> REM REM q07.sql REM REM Get project numbers for projects supplied with part 'P01' REM in an average quantity greater ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search 
 1REM
 2REM q07.sql
 3REM
 4REM Get project numbers for projects supplied with part 'P01'
 5REM in an average quantity greater than the greatest quantity
 6REM in which any part is supplied to project 'J01'.
 7REM
 8
 9SELECT DISTINCT jn
10FROM Shipments
11WHERE pn = 'P1'
12GROUP BY jn
13HAVING AVG(quantity) > (SELECT MAX(quantity)
14                        FROM Shipments
15                        WHERE jn='J01');
Retrieved from "http://wiki.zcubes.com/index.php?title=Yurttas/PL/DBL/oracle/F/01/SPJ/q07.sql&oldid=79795"