Comment count by view count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

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 sites:
loading Hold tight while we fetch your results