List of Brazil-based users by reputation score. Query, naturally, by a Brazilian user.
Q&A about the site for music historians, critics, and fans
-- TOP Users: Brazil -- List of Brazil-based users by reputation score. Query, naturally, by a Brazilian user. -- -- This is the original query! SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation FROM Users WHERE LOWER(Location) LIKE '%brazil%' OR LOWER(Location) LIKE '%brasil%' OR UPPER(Location) LIKE '%BR' ORDER BY Reputation DESC;