instruction: User List: Top N - New York City - with false positive exclusions. List of users in New York City.
response: SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS "#", Id AS "user_link", Reputation, Location, LastAccessDate, UpVotes, DownVotes FROM Users WHERE (LOWER(Location) LIKE '%new york city%' OR UPPER(Location) LIKE '%NYC%') AND NOT (Location LIKE '%AnyCoffeeShop' OR LOWER(Location) LIKE '%nyc area%') AND LENGTH(Location) > 1 ORDER BY Location LIMIT 100