instruction: User's Rank in a location with min rep cap.
response: SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS "#", Id AS "user_link", DisplayName, Reputation, Location, Views, ProfileImageUrl, AboutMe FROM Users WHERE Reputation >= '##repcap##' AND LOWER(Location) LIKE LOWER(N'%##Location##%') ORDER BY Reputation DESC