1
SQLIntermediate#joins#queries
SQLIntermediate#queries
How do you find employees earning more than their department average?
Compare each row against a window average or a grouped subquery on the same department.
Example
SELECT name, salary FROM ( SELECT name, salary, AVG(salary) OVER (PARTITION BY dept_id) avg_sal FROM employees ) t WHERE salary > avg_sal;