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

 1REM
 2REM q06.sql
 3REM
 4REM Get the total quantity of part 'P01' supplied by
 5REM supplier 'S01'.
 6REM
 7
 8SELECT SUM(quantity)
 9FROM Shipments
10WHERE pn = 'P01'
11  AND sn = 'S01';