Q&A for community managers, administrators, and moderators
SELECT top 50 t.Id, t.RANK, t.[USER], t.Location, t.Reputation FROM ( SELECT Id, ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [Rank], DisplayName AS [User], [Location], [Reputation] FROM Users WHERE LOWER(Location) LIKE '%perú%' or LOWER(Location) LIKE '%peru%' )as t