How many comments do I have for each score.
Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment
DECLARE @UserId int = ##UserId## SELECT Count(*) AS CommentCount, Score FROM Comments WHERE UserId = @UserId GROUP BY Score ORDER BY Score DESC