Q&A about the site for professional linguists and others with an interest in linguistic research and theory
-- Find Stack Overflow Top 10 User in the Country
SELECT Id [User Link], Reputation, DisplayName, Location,
DENSE_RANK() OVER (PARTITION BY Reputation ORDER BY DisplayName) RankNo
WHERE Location like '%##Location##%'