n $5$: How do you retrieve the first and last names of employees who do not have any

dependents?

A$)$ SELECT FNAME, LNAME FROM EMPLOYEE WHERE SSN NOT IN $($SELECT

ESSN FROM DEPENDENT$)$;

B$)$ SELECT FNAME, LNAME FROM EMPLOYEE WHERE SSN $=$ ESSN;

C$)$ SELECT FNAME, LNAME FROM EMPLOYEE LEFT JOIN DEPENDENT ON SSN $=$

ESSN WHERE ESSN IS NULL;

D$)$ SELECT FNAME, LNAME FROM EMPLOYEE WHERE SSN NOT IN $($SELECT SSN

FROM DEPENDENT$)$;