A simply query to find users in your city or country. Added user links to the original version.
Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO
-- Find Stack Overflow Users In Your City (with user-links)
-- A simply query to find users in your city or country. Added user links.
select ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS Number,Id [User Link], Reputation, DisplayName, Location
where LOWER(Location) like '%##Location##%'
order by Reputation desc