Cumulative Distribution — Solution & ExplanationProblems / Cumulative Distribution / EditorialApproachCUME_DIST() calculates the fraction of rows in the partition that have a value less than or equal to the current row's value.Formula: count(rows with value <= current) / count(all rows in partition)

Partition: By department so each department is independent.

Order: By salary ascending.

Ties: Rows with the same salary get the same CUME_DIST value.

Key difference from PERCENT_RANK: CUME_DIST ranges from 1/N to 1.0, while PERCENT_RANK ranges from 0.0 to 1.0.Hints

CUME_DIST() computes: (number of rows with value <= current row) / (total rows in partition).

Unlike PERCENT_RANK, CUME_DIST never returns 0 — the minimum is 1/N.

The data intentionally has ties (same salary) to test correct handling.

Solve Cumulative Distribution yourself →