Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
DECLARE @tagName NVARCHAR(255) = '##TagName##' -- TagName: Tag name of the question. DECLARE @beginDate DATETIME = '2016-01-01' DECLARE @endDate DATETIME = GETDATE() SELECT T.Month, T.QuestionCount, (T.QuestionCount - T.UnansweredCount) AS AnsweredCount, T.UnansweredCount, (T.QuestionCount - T.UnansweredCount) / CAST(T.QuestionCount AS DECIMAL) AS AnsswerRate FROM (SELECT CAST( CAST(DATEPART(YEAR, CreationDate) AS NVARCHAR) + '-' + CAST(DATEPART(MONTH, CreationDate) AS NVARCHAR) + '-01' AS DATETIME) AS 'Month', SUM(CAST ( CASE WHEN AnswerCount = 0 THEN 1 ELSE 0 END AS INT)) AS 'UnansweredCount', COUNT(*) AS 'QuestionCount' FROM Posts p INNER JOIN PostTags pt ON p.Id = pt.PostId INNER JOIN Tags t ON t.Id = pt.TagId WHERE (p.PostTypeId = 1) AND (t.TagName = @tagName) AND (p.CreationDate BETWEEN @beginDate AND @endDate) GROUP BY DATEPART(YEAR, CreationDate), DATEPART(MONTH, CreationDate)) T ORDER BY T.Month DESC