Highest Paid Role at Amazon | Dataford Interview Questions

Given a dataset containing a list of worker’s names, their positions, and salaries at Amazon, select the highest-paid Software Engineer at the company.

Asked in the technical screen, this query-writing task uses the employees and positions tables. Ignore workers whose salary is NULL. If multiple eligible workers share the highest salary, return the alphabetically first employee.

Output

Return one row with employee_name, position_title, and salary.
Include only the selected Software Engineer with the highest non-NULL salary.
Order the result by employee_name ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
position_id	INT	Identifier of the employee's position
salary	NUMERIC(12,2)	Annual salary in US dollars

positions

Column	Type	Description
position_idPK	INT	Unique position identifier
position_title	VARCHAR(100)	Position title

Your question is Highest Paid Role at Amazon. Start with the requirements and the two tables 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