178. 分数排名

# Write your MySQL query statement below
SELECT
    s1.score as Score,
    #s2表中有分数大于等于排序后的s1表中的分数就代表排名是多少
    (SELECT COUNT(DISTINCT s2.score) FROM Scores s2 WHERE s2.score>=s1.score) AS `Rank`
FROM
    Scores s1
ORDER BY
    s1.score DESC;