0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

select distinct posts.creationdate, users.location, posts.id, 
posts.title

from users
join posts on posts.owneruserid = users.id

where posts.creationdate >= '2017' 
and lower(users.location) like '%canada%' 
or lower(users.location) like '%nova scotia%'

fork query

edited jan 17 22

created jan 17 22 anonymous