Employee Max Salary Query | Dataford Interview Questions

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

Problem

Xccelerated's engineering directory needs a report showing every employee who earns the company's maximum recorded salary. Write a PostgreSQL query that preserves qualifying employees even when their department is missing from the directory.

Requirements

Find the maximum non-NULL salary across all employees.
Return every employee whose salary equals that maximum, including ties.
Display the employee name, salary, and department name. Use a LEFT JOIN so a qualifying employee without a matching department is retained.
Order the result alphabetically by employee name.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
salary	DECIMAL(10,2)	Annual employee salary
department_id	INT	Reference to the employee's department

departments

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