Q&A for power users of web applications
select ROW_NUMBER() OVER (ORDER BY Reputation DESC) As Rank, Id [User Link], Reputation, DisplayName, Location from Users where Location like '%, MN%' or Location like '%Minnesota%' order by Reputation desc