Find all employees in the sales department by using a nested query.

Question

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

Answer 1

```
SQL> SELECT Lname, Fname
2 FROM employee
3 WHERE DeptId =
4 (SELECT DeptId
5 FROM dept
6 WHERE UPPER(DeptName) = 'SALES');

LNAME FNAME
--------------- ---------------
Shaw Jinku
Garner Stanley
```