Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language
SELECT TOP (230) ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Location, Reputation FROM Users WHERE LOWER(Location) LIKE '%ukraine%' OR LOWER(Location) LIKE '%kiev%' OR LOWER(Location) LIKE '%lviv%' OR LOWER(Location) LIKE '%dnepr%' ORDER BY Reputation DESC;