Get names of students, who received final grade ‘F’ in Winter 2003.

Question

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

Answer 1

```
SQL> SELECT LAST, FIRST, COURSEID, SECTION, FINAL
2 FROM STUDENT S, CRSSECTION C, REGISTRATION R
3 WHERE S.STUDENTID = R.STUDENTID
4 AND R.CSID = C.CSID
5 AND R.FINAL = 'F';

LAST FIRST COURSE SE F
--------------- --------------- ------ -- -
DIAZ JOSE MA150 02 F
```