Employees with 4th to 11th Salaries

MediumSQL · PostgreSQL

Problem

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

Tablesemployees

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.