Top AWS tags - Answered (past 3 months)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu Meta

Q&A about the site for Ubuntu users and developers

SELECT TOP 20
  Tags.TagName as [Tag],
  COUNT(*) as [Count]
FROM PostTags
JOIN Tags ON (PostTags.TagId = Tags.Id)
JOIN Posts Question ON (PostTags.PostId = Question.Id)

WHERE Question.PostTypeId = 1 -- Question
  AND Question.ClosedDate IS NULL -- Exclude Closed questions
  AND AnswerCount = 0 -- Has answers
  AND (Tags.TagName LIKE 'amazon-%' OR Tags.TagName LIKE 'aws-%')
  AND Question.CreationDate > DATEADD(MONTH,-12,GETDATE()) -- Past 3 months

GROUP BY Tags.TagName
ORDER BY COUNT(*) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results