4th Lowest Salary Employee | Dataford Interview Questions

Afiniti’s compensation analytics team needs to identify employees at the fourth-lowest salary level among active employees. Write a PostgreSQL query that returns every employee tied at that salary level, along with the department name when available.

Requirements

Consider only active employees with non-NULL salaries.
Rank distinct salary values from lowest to highest using a window function.
Return all employees with rank 4, including ties, and preserve employees whose department reference has no match.
Return results in ascending employee_id order.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
salary	NUMERIC(10,2)	Annual employee salary
employment_status	VARCHAR(20)	Current employment status
department_id	INTEGER	Referenced department identifier

departments

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

Your question is 4th Lowest Salary Employee. 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