Q&A for gardeners and landscapers
select ROW_NUMBER() OVER (ORDER BY Reputation DESC) As Rank, Id [User Link], Reputation, DisplayName, Location from Users where (Location like '%, RI%' or Location like '%,RI%' or Location like '% RI%' or Location like '%Rhode Island%' or Location like '%Providence%' or Location like '%Newport%') and Location not like '%India%' order by Reputation desc