Azure CLI posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science Meta

Q&A about the site for scientists using computers to solve scientific problems

SELECT 

questions.Id as QuestionId, 

Title, 

Tags, 

Body, 

Answers.AnswerBody, 

AcceptedAnswerId, 

questions.Score as QuestionScore, 

ViewCount, 

AnswerCount, 

CommentCount, 

FavoriteCount, 

questions.CreationDate as QuestionCreationDate, 

LastEditDate, 

LastActivityDate, 

ClosedDate 

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results