Q&A for scientists using computers to solve scientific problems
SELECT q.Id AS QuestionId, q.Title AS QuestionTitle, q.Body AS QuestionBody, a.Id AS AnswerId, a.Body AS AnswerBody FROM Posts q INNER JOIN Posts a ON q.AcceptedAnswerId = a.Id WHERE q.CreationDate >= DATEADD(month, -4, GETDATE()) AND q.CreationDate < GETDATE() AND q.PostTypeId = 1 AND a.PostTypeId = 2 AND q.tags like '%<##tag?powershell##>%'