instruction: Test: List of Users in a given location - Not Case Sensitive. List of Users in a given location. Not Case Sensitive
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 LOWER('%##location##%') OR LOWER(Location) LIKE LOWER('%##AbbreviationRight##')) AND NOT (LOWER(Location) LIKE LOWER('%##Exclusion##%')) ORDER BY Location LIMIT 100