User with highest total comment score

1

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT TOP ##num?100##
c.UserId AS [User Link], c.UserDisplayName,
SUM(c.Score) AS [Total Score], COUNT(c.Id) AS [Total Count], AVG(CAST(c.Score AS decimal)) AS [Average Score],
'site://users/' + CAST(c.UserId AS varchar) + '?tab=activity&sort=comments' AS [Link to comments]
FROM Comments c
GROUP BY c.UserId, c.UserDisplayName
ORDER BY SUM(c.Score) DESC

Enter Parameters

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