Leaderboard percent rank

sql

SELECT player_id,
       score,
       PERCENT_RANK() OVER (ORDER BY score) AS pct_rank
FROM leaderboard;

Explanation

A convenient way to label records as top 5%, top 10%, and so on.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Distribution functions

Bucket rows into 10 groups.

Open In sheetsqlsame section

Identify rows at or above a cumulative threshold.

Open In sheetsqlsame section

Turn NTILE output into a simple segment label.

Assign named score ranges using a window bucket.