Subquery select ซ้อน select

EX.Subquery

SELECT emp.last_name
FROM employees emp
WHERE emp.employee_id NOT IN
(SELECT mgr.manager_idFROM employees mgr);