SO users from Chicago with highest reputation
Q&A for professionals, academics, and students working within the systems development life cycle
-- Top users from Chicago
ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
LOWER(Location) LIKE '%chicago%'
OR UPPER(Location) LIKE '%CHICAGO%'
or Location like '%Chicago%'
or Location like '%ℂ𝕙𝕚𝕔𝕒𝕘𝕠%'
AND Reputation >= 1000