Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language
--select top 20 Text,score from comments order by score desc
--select id, body from posts where favoritecount > 500;
select DisplayName, Location, Reputation,
RANK() OVER(PARTITION BY Location ORDER BY Reputation desc) rank
where location !=''
order by Reputation,rank;