0

Please login or register to vote for this query.

(click on this box to dismiss)

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())

fork query

edited nov 25

created nov 25 anonymous