SQL query

[farrokhp]

Does this query valid , can you interpret it and tell me how does is process

SELECT name, department_id, salary
FROM employee
WHERE (department_id, salary) IN (SELECT department_id, salary
FROM employee
WHERE employee_id = &1)
AND bonus IS NULL;

[tamilselvan]

SELECT name, department_id, salary
FROM employee
WHERE (department_id, salary) IN (SELECT department_id, salary
FROM employee
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.

Your Query is a valid one.