select Scores.Score, x.Rank
from Scores
left join
(select A.Score as Score, count(distinct B.Score) as Rank
from Scores A, Scores B
where A.Score <= B.Score
group by A.Score) as x
on Scores.Score = x.Score
order by Scores.Score DESC