0

Please login or register to vote for this query.

(click on this box to dismiss)

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

view current version

edited feb 17 11

created feb 17 11 Renesis