Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
-- Top 1000 users from Brazil SELECT Top 1000 ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [Rank #], Id AS [User Link], Reputation FROM Users WHERE LOWER(Location) LIKE '%brazil%' OR UPPER(Location) LIKE '%BRAZIL%' or Location like '%Brazil%' OR LOWER(Location) LIKE '%brasil%' OR UPPER(Location) LIKE '%BRASIL%' or Location like '%Brasil%' ORDER BY Reputation DESC;