Top 20 SO Users from Delhi, India
Q&A for meta-discussion of the Stack Exchange family of Q&A websites
-- 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 '%london%' OR UPPER(Location) LIKE '%LONDON%' or Location like '%london%' AND Reputation <= 5000 ORDER BY Reputation DESC;