Find Employee With Max Salary

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Find Employee With Max Salary. 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

Zscaler’s People Analytics team needs to identify the employee or employees with the highest recorded salary and display their department. Write a PostgreSQL query using the employees and departments tables.

Requirements

Return every employee whose salary equals the maximum non-NULL salary in employees, including ties.
Display the employee name, salary, and department name.
Preserve employees whose department assignment is missing or unmatched, and sort the final result by employee name.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department_id	INT	Referenced department assignment
salary	NUMERIC(12,2)	Recorded annual salary

departments

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

Tablesemployeesdepartments

Your solutionPostgreSQL

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

Run a query to see results