Multiple-row Subquery

Multiple-row Subquery — A subquery that returns multiple rows but only one column.

SELECT *
FROM employees
WHERE department IN (
    SELECT department FROM departments
    WHERE location = 'New York'
);