My Comment Score distribution

0

Please login or register to vote for this query.

(click on this box to dismiss)

How many comments do I have for each score.

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT top 100
a.UserId, b.DisplayName, Count(*) AS CommentCount, 
sum(a.Score) As Total, 100*sum(a.Score)/Count(*) as Average
FROM 
    Comments a, Users b
where a.UserId = b.Id
GROUP BY 
    a.UserId, b.DisplayName
ORDER BY 
    Total DESC

Enter Parameters

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