Q&A for programming puzzle enthusiasts and code golfers
select year(creationdate) as [year], month(creationdate) AS [month], t.TagName, avg(AnswerCount) as AverageAnswerCount, sum(viewcount) / count(p.id) as AverageNewQuestionViews, count(p.id) as NewQuestionCount, sum(viewcount) as NewQViewCount from posts p join posttypes pt on p.posttypeid = pt.id join PostTags ptg on ptg.PostId = p.Id join Tags t on t.Id = ptg.TagId where year(creationdate) >= 2014 and pt.name = 'Question' group by year(creationdate), month(creationdate),t.TagName having (sum(viewcount) >=10000 or sum(viewcount) / count(p.id) >= 2000) order by year(creationdate), month(creationdate),t.TagName