Employee vs Department Average

Problem

Return first_name, salary, and the average salary of their department (dept_avg) for each employee, ordered by department then salary descending.

Try It

Hint

Solution