Q&A for scientists, academics, teachers, and students in the field of chemistry
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