SQL interview question: Cumulative Distribution
Cumulative Salary Distribution
Compensation analysts want to see what percentage of employees earn less than or equal to each salary level.
Calculate the cumulative distribution of salaries.
Return salary, employees_at_or_below (count), total_employees, and cumulative_pct (rounded to 1 decimal). Show only distinct salary levels. Order by salary.
Skills: CUME_DIST or manual cumulative calculation
Tables
employees 37 rows
- id integer PK
- first_name text
- last_name text
- email text
- department_id integer → departments
- salary integer
- hire_date text
- manager_id integer → employees
- title text
| id | first_name | last_name | department_id | salary | hire_date | manager_id | title | |
|---|---|---|---|---|---|---|---|---|
| 1 | Alice | Chen | [email protected] | 1 | 250000 | 2015-01-15 | NULL | CEO |
| 2 | Robert | Martinez | [email protected] | 2 | 180000 | 2016-03-20 | NULL | CEO |
| 3 | Sarah | Johnson | [email protected] | 1 | 150000 | 2017-06-10 | 1 | VP Engineering |