Display student Jose Diaz’s faculty advisor’s name and phone number.

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 Name, Phone
2 FROm faculty
3 WHERE FacultyId =
4 (SELECT FacultyID
5 FROM student
6 WHERE UPPER(Last) = 'DIAZ'
7 AND UPPER(First) = 'JOSE');

NAME PHO
--------------- ---
Mobley 529
```