Q&A for programming puzzle enthusiasts and code golfers
select year(creationdate) as [year], month(creationdate) AS [month], Tags, 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 where year(creationdate) >= 2011 and pt.name = 'Question' group by year(creationdate), month(creationdate),Tags order by year(creationdate), month(creationdate),Tags