Problem Statement

Find employees who earn strictly more than the AVG salary of employees who work in departments containing more than 2 employees. Use a 3-level nested subquery: innermost finds 'big' department ids, the middle one averages over them, the outer compares each row. Return employee_id, first_name, last_name, salary, department_name — ordered by salary DESC, employee_id.

Relevant Tables