Q&A for people looking to bypass life's everyday problems with simple tricks
--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 DisplayName,Location ORDER BY Reputation desc) rank
where location !=''
order by Reputation,rank;