Best commenters by average comment score

1

Please login or register to vote for this query.

(click on this box to dismiss)

Users ranked by average comment score.

Stack Overflow en español

Preguntas y respuestas para programadores y profesionales de la informática

-- 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 > 0
GROUP BY
  UserId, Users.Reputation
HAVING
  COUNT(Score) >= ##MinComments:int?20##
ORDER BY
  AvgScore DESC

Enter Parameters

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