SQL Top Salaried People | Dataford Interview Questions

UKG Pro stores employee details separately from compensation records. Write a PostgreSQL query that returns the three highest-paid active salaried employees.

Requirements

Join employee and compensation data using employee_id.
Include only employees whose status is Active and whose compensation type is Salary.
Rank salaries from highest to lowest and return exactly the top three employees.
Return the employee name and annual salary, ordered from highest to lowest salary.

Schema

ukg_employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
full_name	VARCHAR(100)	Employee's full name
employment_status	VARCHAR(20)	Current employment status

ukg_employee_compensation

Column	Type	Description
compensation_idPK	INTEGER	Unique compensation record identifier
employee_id	INTEGER	References ukg_employees.employee_id
pay_type	VARCHAR(20)	Compensation basis, such as Salary or Hourly
annual_salary	NUMERIC(12,2)	Annual salary amount

Your question is SQL Top Salaried People. 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