Find Employees with Above-Average Salary
Query employees who earn more than the company’s average salary.
SQL
query
Mã nguồn
1SELECT name, salary
2FROM employees
3WHERE salary > (SELECT AVG(salary) FROM employees);
4Về tác giả
Query employees who earn more than the company’s average salary.
1SELECT name, salary
2FROM employees
3WHERE salary > (SELECT AVG(salary) FROM employees);
4