Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
questions.Id as QuestionId,
questions.Score as QuestionScore,
questions.CreationDate as QuestionCreationDate,
FROM Posts as questions
LEFT OUTER JOIN ( SELECT Id as AnswerId, Body as AnswerBody
FROM Posts WHERE PostTypeId = 2) as Answers
ON questions.AcceptedAnswerId = answers.AnswerId
WHERE questions.PostTypeId = 1
AND questions.CreationDate >= '01-01-2015 00:00:00'
AND questions.Tags LIKE '%azure%'
AND questions.score > 0
AND questions.DeletionDate IS NULL
AND ParentId IS NULL
AND questions.CommunityOwnedDate IS NULL
AND YEAR(questions.CreationDate) > 2020