1

Please login or register to vote for this query.

(click on this box to dismiss)

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

view current version

edited mar 7 14

created mar 7 14 Jonathan Van Matre