Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
DECLARE @from_date AS date = '##FromDate##' DECLARE @to_date AS date = '##ToDate##' SELECT SUM(CAST(CommentCount AS BIGINT)) AS comment_count FROM Posts WHERE PostTypeId = 1 AND CreationDate > @from_date AND CreationDate < @to_date AND Tags LIKE '%##Tag##%'