Problem Statement

List the three highest-paid employees in each department, with their in-department rank. Return department_name, first_name, last_name, salary, dept_rank — ordered by department_name, dept_rank.

Relevant Tables