What does the following query return? SELECT * FROM employees WHERE department_id = ANY (SELECT id FROM departments WHERE budget > 500000)

Question

SQL Fundamentals — Hard

What does the following query return? SELECT * FROM employees WHERE department_id = ANY (SELECT id FROM departments WHERE budget > 500000)

Accepted Answer

The query returns employees in any department whose budget exceeds 500000. It uses the ANY operator to compare the department_id with the result of the subquery that filters departments with a budget over 500000.