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, convert(float,sum(a.Score))/Count(*) as Average
Comments a, Users b
where a.UserId = b.Id