Correlated Subqueries: Examples

Above Department Average

intermediate

Find employees earning above their department average

SELECT name, department, salary FROM employees e WHERE salary > (SELECT AVG(salary) FROM employees e2 WHERE e2.department = e.department);

name | department | salary

Alice | Engineering | 95000

Bob | Sales | 85000

Subquery references outer query department. Executes once per employee to calculate department average.

All