SQL Join for Top Earners | Dataford Interview Questions

Roku's People Analytics team needs a simple report of the employees with the highest current salaries. Write a PostgreSQL query using the employees table only.

Requirements

Return the employee ID, employee name, and salary for the two highest-paid employees.
Sort salaries from highest to lowest, place NULL salaries last, and use employee_id as a deterministic tie-breaker.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
team	VARCHAR(100)	Roku team or department
salary	NUMERIC(10,2)	Current annual salary in USD

Your question is SQL Join for Top Earners. Start with the requirements and the one table 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

Roku's People Analytics team needs a simple report of the employees with the highest current salaries. Write a PostgreSQL query using the employees table only.

Requirements

Return the employee ID, employee name, and salary for the two highest-paid employees.
Sort salaries from highest to lowest, place NULL salaries last, and use employee_id as a deterministic tie-breaker.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
team	VARCHAR(100)	Roku team or department
salary	NUMERIC(10,2)	Current annual salary in USD

Your question is SQL Join for Top Earners. Start with the requirements and the one table 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.