Q&A about the site for enthusiasts and power users of Windows Phone OS
-- Top Users by Country -- Created by Mehrdad Dowlatabadi (stackoverflow.com/users/9714791/mehrdad-dowlatabadi) SELECT ROW_NUMBER() OVER(ORDER BY count(*)) Rank,Location,count(*) FROM Users Where Reputation>1 Group By Location Having count(*)>5 Order By count(*) DESC