# Write your MySQL query statement below
select a.score ,
(select count(distinct score) from Scores b where b.score>=a.score) as `Rank`
from Scores a
order by `Rank`
select a.score, count(distinct b.score) as `Rank`
from Scores a , Scores b
where b.score>=a.score
group by a.Id
order by `Rank`