Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
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