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

 1REM
 2REM q02.sql
 3REM
 4REM Get supplier numbers for suppliers with a status lower
 5REM than that of supplier 'S01'.
 6REM
 7
 8SELECT sn
 9FROM Suppliers
10WHERE status < (SELECT status
11                FROM Suppliers
12                WHERE sn='S01');