Users by Comments per Post

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

select top 250 p.OwnerUserID, (c.comments * 1.0)/count(*)
from Posts p
inner join 
   (select p.OwnerUserID, count(*) comments
    from comments c
    inner join Posts p on p.ID = c.PostID
    group by p.OwnerUserID  ) c on c.OwnerUserId = p.OwnerUserID
group by p.OwnerUserId, c.comments
order by (c.comments * 1.0)/count(*) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results