Find Employees with Above-Average Salary
Query employees who earn more than the company’s average salary.
SQL
query
Code
1SELECT name, salary
2FROM employees
3WHERE salary > (SELECT AVG(salary) FROM employees);
4About the Author
Query employees who earn more than the company’s average salary.
1SELECT name, salary
2FROM employees
3WHERE salary > (SELECT AVG(salary) FROM employees);
4