Find employees earning more than the average salary of their own department.

Answer preview

Compute each department's average alongside every employee with AVG() OVER (PARTITION BY dept_id), then filter in an outer query.…