Highest Paid Employee Per Department | Dataford Interview Questions

Data Axle needs a department-level compensation report. Write a PostgreSQL query that returns every employee whose salary equals the highest non-null salary in their department.

Requirements

Use the department and employee data to identify the highest salary within each department.
Include all employees tied for the highest salary.
Exclude employees with null salaries and departments without qualifying employees.
Return results ordered by department name and employee name.

Schema

departments

Column	Type	Description
department_idPK	INTEGER	Unique department identifier
department_name	VARCHAR(100)	Department name

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
department_id	INTEGER	Referenced department identifier
employee_name	VARCHAR(100)	Employee full name
job_title	VARCHAR(100)	Employee job title
salary	NUMERIC(12,2)	Annual employee salary

Your question is Highest Paid Employee Per Department. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem