What does the following subquery pattern do? SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees)

Question

SQL Data Analyst — Medium

What does the following subquery pattern do? SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees)

Accepted Answer

The subquery pattern in the question compares each employee's salary to the average salary of all employees. Therefore, the main query will return only those employees whose salary is higher than the company average.