1

Please login or register to vote for this query.

(click on this box to dismiss)

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
FROM Users
WHERE (UPPER(Location) LIKE '%MEXICO%' 
OR UPPER(Location) LIKE '%MX%')
AND UPPER(Location) NOT LIKE '%NEW MEXICO%'
ORDER BY Reputation DESC

fork query

edited apr 23 14

created apr 22 14 darkajax