Find name of the supervisor for employee number 433.

Question

Use the NamanNavan (N2) Corporation database tables to design the following queries. (Use the spooling method to capture all queries and results in the CHAP7SP1.LST file.)

Answer 1

```
SQL> SELECT E.LNAME "EMPLOYEE", S.LNAME "SUPERVISOR"
2 FROM EMPLOYEE E, EMPLOYEE S
3 WHERE E.SUPERVISOR = S.EMPLOYEEID
4 AND E.EMPLOYEEID = 433;

EMPLOYEE SUPERVISOR
--------------- ---------------
MCCALL DEV
```