AWS Questions by Month - Elemental

1

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT 
  CONVERT(nvarchar(7), Question.CreationDate, 23) AS Month,
  COUNT(Question.Id) AS Questions,
  COUNT(NULLIF(AnswerCount,0)) AS Answers,
  CONCAT(100 * COUNT(NULLIF(AnswerCount,0)) / COUNT(1), '%') as AnswerRate,
  CONCAT(100 * COUNT(AcceptedAnswerId) / COUNT(1), '%') as AcceptedRate,
  SUM(Question.ViewCount) AS Views

FROM Posts as Question

WHERE PostTypeId = 1 -- Question
  AND Question.ClosedDate IS NULL -- Exclude Closed questions
  AND (Question.Tags LIKE '%<aws-media%' OR Question.Tags LIKE '%<aws-elemental%')
  AND Question.CreationDate >= '2019-01-01'
  --AND Question.CreationDate < DATEADD(DAY,1,EOMONTH(GETDATE(),-1))
--and Question.Id = 40575584

GROUP BY CONVERT(nvarchar(7), Question.CreationDate, 23)
ORDER BY CONVERT(nvarchar(7), Question.CreationDate, 23)

Enter Parameters

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