Comment count by view count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select
  p.ViewCount / 1000 as [kViews],
  -- count(*) as [Post count],
  -- sum(p.CommentCount) as [Total comment count],
  sum(p.CommentCount) / count(*) as [Average comment count]
from Posts p
where p.CommentCount != 0
group by p.ViewCount / 1000
order by p.ViewCount / 1000

Enter Parameters

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