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
Comments a, Users b
where a.UserId = b.Id