Is there a way to know what the rank is in my country by reputation from Stack Overflow?
Such as see rankings by week or month.
Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.Sign up to join this community
I have created the following query for you, to list your rank among users based on a location.
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
I leave it as an exercise for the reader to add joins with the posts table to include question and answer counts. Use the great tutorial to learn how that can be done.
When run today you'll find yourself on spot 6:
It isn't doable to determine what your position was last week, last month or last year because that would require to recalculate your reputation and that of your peers for that specific moment in time which is both incomplete due to missing data and the query will run longer then 2 minutes causing a timeout.
You can however run this every week, preferable after the update of SEDE on Sunday, to see if you are making progress.