Back to Developer Roadmap

Employees Above Average Salary

src/data/question-groups/sql-queries/content/employees-above-average-salary.md

4.0761 B
Original Source

Given an Employees table with columns id, name, and salary that looks like this:

idnamesalary
1Irene1000
2Peter1230
3Raymond1450
4Henry1790
5Naomi2350
6Bridget2000
7Emily2500
8Great3000
9Mercedes2750
10Zoe2900

The query to find employees earning more than the average salary is:

sql
SELECT * FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
idnamesalary
5Naomi2350
7Emily2500
8Great3000
9Mercedes2750
10Zoe2900