Query Rewrites: Sub-queries
SELECT Emp.Name
FROM Emp
WHERE Emp.Age < 30
AND
Emp.Dept#
IN
(
SELECT Dept.Dept#
FROM Dept
WHERE
Dept.Loc = Seattle
AND
Emp.Emp#=Dept.Mgr)