Problem Statement

For each department, label employees whose salary equals the dept MAX as 'Highest', the dept MIN as 'Lowest', everyone else 'N/A'. If a department has only one employee, label that row 'Highest'. Return department_id, employee_id, first_name, last_name, salary, salary_label — ordered by department_id, salary DESC, employee_id.

Relevant Tables