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;
Printable View
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;
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.