Q&A for gardeners and landscapers
-- TOP 10 Users in Brazil
-- List of TOP 10 Brazil-based users by reputation score.
-- Query written by Leniel Macaferi.
SELECT TOP 10
ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
LOWER(Location) LIKE '%brazil%' OR
LOWER(Location) LIKE '%brasil%' OR
UPPER(Location) LIKE '%BR'