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');