Q&A for community managers, administrators, and moderators
-- top users: Turkey
-- List of Turkey-based users by reputation score. Query, naturally, by a turkish user.
-- This is the original query!
TOP (100) ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
LOWER(Location) LIKE '%israel%'
OR UPPER(Location) LIKE '%IL'