Top 20 SO Users from Delhi, India
Q&A for people looking to bypass life's everyday problems with simple tricks
-- Top 20 users from Delhi India SELECT TOP 20 ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation, Location FROM Users WHERE LOWER(Location) LIKE '%delhi%' OR UPPER(Location) LIKE '%DELHI%' or Location like '%delhi%' AND Reputation >= 10000 ORDER BY Reputation DESC;