Delete rows from SP03SECT table for faculty Mobley.

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> DELETE FROM sp03sect
2 WHERE FacultyId =
3 (SELECT FacultyId
4 FROM faculty
5 WHERE UPPER(Name) = 'MOBLEY');

2 rows deleted.

SQL> SELECT * FROM sp03sect;

COURSE SE FACULTYID ROOMID
------ -- ---------- ----------
CIS265 01 14
CIS265 02 111 18
LA123 05 15
CIS253 11 111 18
```