leetcode mysql 178. 分数排名

# Write your MySQL query statement below
select
 t1.Score,
count(distinct t2.Score)+1 as Rank
from
Scores as t1
left join
Scores as t2
on
t1.Score<t2.Score
group by t1.ID
order by Rank asc