New Questions View Analysis by Tags


Please login or register to vote for this query.

(click on this box to dismiss)

Programming Puzzles and Code Golf

Q&A for programming puzzle enthusiasts and code golfers

select year(creationdate) as [year], 
  month(creationdate) AS [month],
  avg(AnswerCount) as AverageAnswersPerQuestion,
  sum(viewcount) / count( as AverageNewQuestionViews, 
  count( as NewQuestionCount, 
  sum(viewcount) as NewQViewCount 
from posts p
join posttypes pt on p.posttypeid =
join PostTags ptg on ptg.PostId = p.Id
join Tags t on t.Id = ptg.TagId
where (year(creationdate) >= 2014 
OR (year(creationdate)=2013 AND month(creationdate)=12)) 
  and = 'Question'
group by year(creationdate), month(creationdate),t.TagName 
  having (sum(viewcount) >=10000
  or sum(viewcount) / count( >= 2000
  or sum(viewcount) / count( >= 2000)
order by year(creationdate), month(creationdate),t.TagName

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results