Highest Paid Employee Per Department

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Highest Paid Employee Per Department. Start with the requirements and the two tables on the right.

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

You need to log in / sign up to run or submit.

Problem

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

Tablesdepartmentsemployees

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results