Problem Statement

Find the single highest-paid employee in each department (ties broken by employee_id). Use ROW_NUMBER in a CTE and filter to rn = 1. Return department_name, first_name, last_name, salary — ordered by department_name.

Relevant Tables