Highest Salary Department Employee IDs | Dataford Interview Questions

Your question is Highest Salary Department Employee IDs. 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

Snapmint’s People Analytics team wants to identify all employees working in the department of the company’s highest-paid employee. Write a PostgreSQL query that returns the relevant employee and department details.

Requirements

Identify the employee department associated with the maximum non-NULL salary across the employees table.
Return every employee in that department, including the highest-paid employee.
Include the employee ID, employee name, job title, department name, and salary.
Sort the results by salary descending, with employee ID ascending as a tie-breaker.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee’s full name
department_id	INT	References departments.department_id
job_title	VARCHAR(100)	Employee’s job title
salary	NUMERIC(12,2)	Annual employee salary

departments

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