IntermediateWHERE & Filtering

Find employees whose salary is above average

The query

SQL

SELECT first_name, last_name, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees)
ORDER BY salary DESC;

Tested against PostgreSQL 16

Note

“Scalar subquery in WHERE clause — returns single value used for comparison.