AWS Questions by Month - Elemental


Please login or register to vote for this query.

(click on this box to dismiss)

Movies and TV Meta

Q&A about the site for movie and tv enthusiasts

  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.CreationDate >= '2019-01-01'
  AND (Body LIKE '"MediaLive"')
  --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

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