Q&A about the site for music historians, critics, and fans
SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS 'Rep Rank',
Id AS [User Link], Reputation, Location,
Views, UpVotes, DownVotes, Age
WHERE (UPPER(Location) LIKE '%MEXICO%'
OR UPPER(Location) LIKE '%MX%')
AND UPPER(Location) NOT LIKE '%NEW MEXICO%'
ORDER BY Reputation DESC