easy · ~8 min
The game team wants to display everyone who achieved one of the top 3 distinct scores on the leaderboard.
leaderboard
Write a query that returns all qualifying players and their score tier:
score_rank
1
2
3
player
score
Input contract: player is unique and non-null; score is a non-null integer. Multiple players may share the same score.