Comment count by view count


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

  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

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