Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software
select ROW_NUMBER() OVER (ORDER BY (SELECT 1)) As Rank, Id [User Link], Reputation, DisplayName, Location from Users where Location like '%, MN%' or Location like '%Minnesota%' order by Reputation desc