Percent Rank Scores — Solution & ExplanationProblems / Percent Rank Scores / EditorialApproachPERCENT_RANK() calculates the relative rank of a row as a decimal between 0 and 1.Formula: (rank - 1) / (total_rows_in_partition - 1)

No partition: All students are ranked together.

ORDER BY score: Ranks from lowest to highest score.

Result: The lowest scorer gets 0.0, the highest gets 1.0, and others are distributed proportionally.

This is useful for understanding where a value falls in a distribution — similar to percentiles in statistics.Hints

PERCENT_RANK() computes (rank - 1) / (total_rows - 1), returning a value between 0 and 1.

No PARTITION BY is needed here — rank across all students.

The lowest score gets percent_rank = 0.0, the highest gets 1.0.

Solve Percent Rank Scores yourself →