Top 20 SO Users from Delhi, India
Q&A for participants in team and individual sport activities
-- Top 10 SO Users from Shillong, IN SELECT TOP 1000 ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation, Location FROM Users WHERE LOWER(Location) LIKE '%india%' OR UPPER(Location) LIKE '%INDIA%' or Location like '%india%' AND Reputation >= 5000 ORDER BY Reputation DESC;