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.

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.

SELECT TOP ##MaxResults:int?25##
  UserId AS [User Link],
  SUM(Score) AS Score,
  COUNT(Score) AS Comments,
  ROUND(AVG(CAST(Score AS FLOAT)), 3) AS AvgScore,
  ROUND(STDEV(Score), 3) AS StdDev,
  MAX(Score) AS TopScore,
  ROUND((SUM(Score) - MAX(Score))/(Count(Score) - 1.0), 3) AS AvgScoreWOTop
FROM
  Comments
INNER JOIN
  Users ON Users.Id = UserId
WHERE
  UserId = 479156 AND Score < 20
GROUP BY
  UserId, Users.Reputation
HAVING
  COUNT(Score) >= ##MinComments:int?20##
ORDER BY
  AvgScore DESC

Enter Parameters

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