Employees with 4th to 11th Salaries | Dataford Interview Questions

Write a SQL query to list employees with the 4th through 11th lowest salaries.

Use the employees table. Treat each employee as a separate position, order salaries ascending, place NULL salaries last, and break salary ties by employee_id ascending.

Output

One row per selected employee
Columns: employee_id, employee_name, salary, salary_position
Include positions 4 through 11, ordered by salary_position

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
salary	NUMERIC(10,2)	Annual employee salary

Your question is Employees with 4th to 11th Salaries. 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