Percent Rank and Cumulative Distribution

The Statistical View

Data science needed a more nuanced ranking: not just 1st, 2nd, 3rd, but a percentage showing relative standing.

`PERCENT_RANK()`: Relative rank as a percentage (0 to 1).

`CUME_DIST()`: Cumulative distribution (what % of rows are at or below this value?).

SELECT

name, score,

PERCENT_RANK() OVER (ORDER BY score) AS pct_rank,

CUME_DIST() OVER (ORDER BY score) AS cume_dist

FROM test_scores;

These are the SQL equivalents of statistical percentile functions. Great for identifying outliers or benchmarking performance.

*Day 68: Filtering Window Function Results.*