List of users in 'Location', by reputation score. Forked from an original query by BoltClock.
Q&A for programming puzzle enthusiasts and code golfers
-- Top users by location -- List of users in 'Location', by reputation score. -- -- Forked from an original query by BoltClock. SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation FROM Users WHERE LOWER(Location) LIKE LOWER('%##Location##%') ORDER BY Reputation DESC;