Q&A about the site for people who use Blender to create 3D graphics, animations, or games
SELECT DATEADD(month, DATEDIFF(month, 0, q.CreationDate), 0) AS Month, SUM(q.ViewCount) AS TotalViews from posts as q INNER JOIN PostTags AS P ON P.PostId = Q.Id INNER JOIN Tags AS T ON T.Id = P.TagId WHERE q.PostTypeId = 1 -- This filters to only questions (PostTypeId = 1) AND (T.TagName = 'itext' or T.TagName = 'xmlworker' or T.TagName = 'itext7' or T.TagName = 'itextpdf' or T.TagName = 'itextsharp' or T.TagName = 'itextg') GROUP BY DATEADD(month, DATEDIFF(month, 0, q.CreationDate), 0) ORDER BY Month DESC