SQL Practice Logo

SQLPractice Online

Level 4 - Mid-LevelQuery-Based Questions

NTILE Salary Banding by Department

Assign each employee into salary quartiles within department and return employee_id, department_id, salary, salary_quartile.

Schema Context

employees(id, department_id, salary)