Salary Distribution Per Department (PERCENT_RANK & CUME_DIST)

Interview brief

Understand the request

For each employee show their PERCENT_RANK and CUME_DIST within their department (ascending salary), both rounded to 4 decimals. Return department_name, first_name, last_name, salary, percent_rank, cume_dist — ordered by department_name, salary, employee_id.

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

SELECT d.department_name, e.first_name, e.last_name, e.salary, ROUND(PERCENT_RANK() OVER (PARTITION BY e.department_id ORDER BY e.salary), 4) AS percent_rank, ROUND(CUME_DIST() OVER (PARTITION BY e.department_id ORDER BY e.salary), 4) AS cume_dist FROM employees e INNER JOIN departments d ON e.department_id = d.department_id ORDER BY d.department_name, e.salary, e.employee_id;

Expected result

Use this output to verify values, aliases, ordering, and row count.

Previewing 10 of 15 expected rows. Run the query in the editor to inspect the full result.