Filter by a department's budget

Question

Accepted Answer

The subquery returns department ids where budget > 100000 - only Eng (id=20). The outer query then keeps employees whose dept_id is in that set - only Bob (dept_id=20). Subquery with IN is equivalent to a JOIN but is often more readable when you only need data from one table in the final result.