How many comments do I have for each score.
Q&A for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences
DECLARE @UserId int = ##UserId## SELECT Count(*) AS CommentCount, Score FROM Comments WHERE UserId = @UserId GROUP BY Score ORDER BY Score DESC