Q&A for spacecraft operators, scientists, engineers, and enthusiasts
SELECT DATEPART(wk, q.CreationDate) AS [WEEK], COUNT(q.Id) AS [NUMQUESTIONS], SUM(q.ViewCount) AS [NUMVIEWS], SUM(q.AnswerCount) AS [NUMANSWERS], SUM(q.CommentCount) AS [NUMCOMMENTS] -- MEDIAN(q.Score, FROM Posts q INNER JOIN PostTags pt ON q.Id = pt.PostId INNER JOIN Tags t ON pt.TagId = t.Id WHERE (q.PostTypeId=1) ---only questions (although answers do not have tags, so this is not necessary) -- AND (t.TagName in ('oracle','oracle-cloud-infrastructure')) AND (t.TagName in ('oracle-cloud-infrastructure')) and q.CreationDate < '2021-12-01' and q.CreationDate >= '2021-06-01' -- GROUP BY t.TagName; GROUP BY DATEPART(wk, q.CreationDate) ORDER BY DATEPART(wk, q.CreationDate) ASC;