User with highest total comment score

1

Please login or register to vote for this query.

(click on this box to dismiss)

The Great Outdoors

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

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 sites:
loading Hold tight while we fetch your results