instruction: User List: Top N - Location/abbreviation. Enter more than one character for location.
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 Location LIKE UPPER('%##LocAbbreviation##') AND LENGTH(Location) > 1 LIMIT 100