Find faculty members who do not teach any course in Spring 2003 semester. Use correlated subquery with NOT EXISTS operator on SP03SECT table.

Question

Use the Indo–US College database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP2.LST file)

Answer 1

```
SQL> SELECT FacultyId, Name
2 FROM faculty o
3 WHERE NOT EXISTS
4 (SELECT '1'
5 FROM sp03sect
6 WHERE FacultyId = o.FacultyId);

FACULTYID NAME
---------- ---------------
222 Williams
123 Mobley
235 Vajpayee
345 Sen
444 Rivera
555 Chang
333 Collins

7 rows selected.
```