Users ranked by average comment score. Must have left 75 comments.
Q&A for committed Christians, experts in Christianity and those interested in learning more
-- Best commenters by average comment score -- Users ranked by average comment score. Must have left 75 comments. SELECT Users.Reputation AS Rep, UserId AS [User Link], SUM(Score) AS Score, COUNT(Score) AS Comments, AVG(Score) AS AvgScore, ROUND(STDEV(Score),2) as StdDev FROM Comments INNER JOIN Users ON Users.Id = UserId WHERE UserId > 0 GROUP BY UserId, Users.Reputation HAVING COUNT(Score) > 75 ORDER BY AvgScore DESC