instruction: Top Stackoverflow users in san fran.
response: SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS "#", Id AS "user_link", Reputation FROM Users WHERE LOWER(Location) LIKE '%francisco%' OR UPPER(Location) = 'CA' ORDER BY Reputation DESC