0

Please login or register to vote for this query.

(click on this box to dismiss)

Users ranked by total sum comment score.

Q&A about the site for people looking to improve their interpersonal communication skills

-- Most popular commenters
-- Users ranked by total sum comment score.

SELECT TOP 500
  UserId AS [User Link],
  sum(Score) As TotalScore,
  Users.Reputation as Rep,
  ROUND(cast(sum(Score) AS FLOAT)/Users.Reputation, 2) as CommentRepRatio
FROM
  Comments
INNER JOIN
  Users ON Users.Id = UserId
WHERE
  UserId > 0
GROUP BY
  UserId, Users.Reputation
ORDER BY 
  TotalScore DESC

fork query

created feb 17 11 Renesis