instruction: Top SO users from NYC.
response: SELECT ROW_NUMBER() OVER (ORDER BY u.Reputation DESC) AS "#", u.Id AS "user_link", u.Reputation, u.Location FROM Users AS u JOIN Badges AS b ON u.Id = b.UserId WHERE b.Name = 'javascript' AND b.Class = 3 AND u.Reputation >= 1000 AND (LOWER(u.Location) LIKE '%nyc%' OR UPPER(Location) LIKE '%NY, NY%' OR LOWER(Location) LIKE '%staten%' OR LOWER(Location) LIKE '%bronx%' OR LOWER(Location) LIKE '%queens%' OR LOWER(Location) LIKE '%new york, ny%' OR LOWER(Location) LIKE '%manhattan%' OR LOWER(Location) LIKE '%brooklyn%') ORDER BY u.Reputation DESC