@@ -0,0 +1,199 @@
+# Write your MySQL query statement below%0Aselect a.Score, sum(case when b.Score%3E=a.Score then 1 end) as Rank from Scores a, (select distinct Score from Scores ) b group by a.id order by a.Score desc; 

add no.178