https://meta.stackexchange.com/questions/194149/can-i-see-country-wise-rankings
Q&A for serious players and enthusiasts of poker
select row_number() over(order by reputation desc) , reputation , views , case when upvotes > 0 then cast(downvotes as decimal)/upvotes else 0 end as [d/u rate] , id as [User Link] , location from users where location like '%' + ##location:string## + '%' collate SQL_Latin1_General_CP1_CI_AI order by reputation desc