0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for network engineers

select top 250 p.OwnerUserID [User Link], (c.comments * 1.0)/count(*) CommentsPerPost
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
having count(*) >= 10
order by (c.comments * 1.0)/count(*) desc

fork query

created mar 20 13 anonymous