Best commenters by average comment score

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.

Christianity

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
  UserId AS [User Link],
  sum(Score) AS Score,
  count(Score) AS Comments,
  avg(Score) AS AvgScore,
  Users.Reputation AS Rep
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

Enter Parameters

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