Statistics on site comments


Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select avg((numComments*1.0)/numPosts) as commentPostRatioAverage, stdev((numComments*1.0)/numPosts) as commentPostRatioStDev 
from (select count(*) as numComments, as userid
        from comments join users on (comments.userid =
       group by nC join 
     (select count(*) as numPosts, as userid
       from posts join users on (posts.owneruserid =
      group by nP on (nC.userid = nP.userid)

Enter Parameters

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