instruction: Buscando Posts que teve qualquer atividade sobre windows phone de 2018 para hoje.
response: SELECT DISTINCT (p.Id), LastActivityDate, p.CreationDate, p.Score, p.ViewCount, p.Body, p.OwnerUserId, p.Title, p.Tags, p.AnswerCount FROM Posts AS p LEFT JOIN Comments AS c ON c.PostId = p.Id LEFT JOIN Votes AS v ON v.PostId = p.Id LEFT JOIN SuggestedEdits AS sg ON sg.PostId = p.Id LEFT JOIN PostLinks AS pl ON pl.PostId = p.Id LEFT JOIN PendingFlags AS pf ON pf.PostId = p.Id LEFT JOIN PostHistory AS ph ON ph.PostId = p.Id LEFT JOIN PostFeedback AS pfb ON pfb.PostId = p.Id WHERE p.Tags LIKE '%<windows-phone%' AND PostTypeId = 1 AND (c.CreationDate >= '01/01/2018' OR v.CreationDate >= '01/01/2018' OR sg.CreationDate >= '01/01/2018' OR pl.CreationDate >= '01/01/2018' OR pf.CreationDate >= '01/01/2018' OR pf.CreationDate >= '01/01/2018' OR pfb.CreationDate >= '01/01/2018') ORDER BY LastActivityDate DESC