SO users from Poznań with reputation over 1000
Q&A for professional and enthusiast programmers
-- Top users from Poznań, Poland SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation, LastAccessDate FROM Users WHERE (LOWER(Location) LIKE '%poznan%' or Location like '%Poznan%' or LOWER(Location) LIKE '%pozna%poland%' --because some guys use "ń" char in city name or Location like '%Pozna%Poland%' or LOWER(Location) LIKE '%pozna%polska%' or Location like '%Pozna%Polska%') --because some guys use "Polska" AND Reputation >= 1000 ORDER BY Reputation DESC;