This query lists all users in a given location sorted by reputation.
Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition
-- List of Users in a given location -- This query lists all users in a given location sorted by reputation. -- Declare @location varchar = ##location## select Id as [User Link], location, reputation from users where location like '%##location##%' order by reputation desc