instruction: Top 25 SO Users from Delhi. Top 30 SO Users from Pune, Maharashtra, India
response: SELECT 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%' ORDER BY Reputation DESC LIMIT 25