0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

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 '%oracle-cloud%')
  AND Question.CreationDate >= '2016-01-01'
  --AND Question.CreationDate < DATEADD(DAY,1,EOMONTH(GETDATE(),-1))

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

fork query

edited jan 26 datahenrik

created jan 26 anonymous