Q&A about the site for music historians, critics, and fans
--who live in your city (hint: there’s a column with their geographic data in it),
--OR who have your city in their name,
--who have accessed StackOverflow in the last year.
Select * From users
Where (location = 'chicago' or
displayname like '%chicago%')
and LastAccessDate > Dateadd(year, -1, getdate())