Q&A about the site for members of the workforce navigating the professional setting
SELECT --TOP 20 --DATEPART(week, Posts.CreationDate) --CONVERT(date, Posts.CreationDate), MIN(Posts.CreationDate), COUNT(*) / 7.0 as 'posts per day' FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.Id = PostTags.PostId WHERE Tags.tagname = 'c++' GROUP BY DATEPART(week, Posts.CreationDate), DATEPART(year, Posts.CreationDate) ORDER BY MIN(Posts.CreationDate)