Yurttas/PL/DBL/mysql/F/01/00/SPJ/q03.sql

 1/*
 2REM
 3REM q03.sql
 4REM
 5REM Get supplier numbers for suppliers supplying some project
 6REM with part 'P02' in a quantity greater than the
 7REM average shipment quantity of part 'P02' for that project.
 8REM
 9*/
10
11\. set-db.sql
12
13SELECT DISTINCT S.sn
14FROM Shipments S
15WHERE pn = 'P2'
16  AND quantity > (SELECT AVG(T.quantity)
17                  FROM Shipments T
18                  WHERE pn = 'P2'
19                    AND S.jn = T.jn);