Use set operator and subquery to find employees, who do not have any dependents.

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.)

```
SQL> SELECT Lname, Fname
2 FROM employee
3 WHERE EmployeeId IN
4 (SELECT EmployeeId FROM employee
5 MINUS
6 SELECT DISTINCT EmployeeId FROM dependent);

LNAME FNAME
--------------- ---------------
Roberts Sandi
Garner Stanley
Houston Larry
McCall Alex
```