SELECT name, department_id, salary
WHERE (department_id, salary) IN (SELECT department_id, salary
WHERE employee_id = &1)
AND bonus IS NULL;
First convert this into plain english:
Show me a list of Sales employees, their departments, and their salary where nobody got bonus and their departments and salary should match which Director of Sales.