Create a new table, SP03SECT, for Spring 2003 semester course sections using a subquery. Include CourseId, Section, FacultyId and RoomId columns only.

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> CREATE TABLE sp03sect
2 AS
3 SELECT CourseId, Section, FacultyId, RoomId
4 FROM crssection
5 WHERE TermId = 'SP03';

Table created.

SQL> SELECT * FROM sp03sect;

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