Q&A for professional and enthusiast programmers
select Rank() over (order by count(*) desc) as Rank, UserId as [User Link], count(*) as Count from badges where lower(Name) = lower(##Language1:string##) group by UserId order by count(*) desc;