LeetCode Rank Scoresを解いてみた

問題

https://leetcode.com/problems/rank-scores/

解いた

SELECT
    score,
    DENSE_RANK() OVER (ORDER BY score DESC) 'rank'
FROM
    Scores
ORDER BY
    score DESC;

結果