How many comments do I have for each score.
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, sum(a.Score)/Count(*) as Average
Comments a, Users b
where a.UserId = b.Id