Problem Statement

Return the highest-paid employee in EACH department. If two employees tie for highest in a department, return BOTH. Show department_id, first_name, last_name, salary — ordered by department_id then first_name.

Relevant Tables