178. Rank Scores

select s1.score Score, count(*) Rank from Scores s1,
(select distinct score from scores) s2
where s1.score <= s2.score
group by id,s1.score
order by count(*)