CUME_DIST

1
SELECT
2
  name,
3
  score,
4
  CUME_DIST() OVER (ORDER BY score) as cume_dist,
5
  ROUND(CUME_DIST() OVER (ORDER BY score) * 100, 1) as cumulative_pct
6
FROM students;

1
SELECT
2
  name,
3
  score,
4
  PERCENT_RANK() OVER (ORDER BY score) as prank,
5
  CUME_DIST() OVER (ORDER BY score) as cdist
6
FROM students;

1
SELECT
2
  month,
3
  revenue,
4
  CUME_DIST() OVER (ORDER BY revenue) as revenue_percentile
5
FROM monthly_revenue
6
ORDER BY revenue;