Employee Rank Within Department

Problem

Return department name, first_name, salary, and dept_rank (by salary descending within department) for each employee, ordered by department then dept_rank.

Try It

Hint

Solution