SQL Correlated Subquery
What makes this a correlated subquery?
SELECT name, salary
FROM employees e1
WHERE salary > (SELECT AVG(salary)
FROM employees e2
WHERE e2.department = e1.department);
Sign in to answer questions and track your progress
Sign In