Q&A for professional and enthusiast programmers
DECLARE @UserId int = ##UserId## DECLARE @AnswerPostTypeId int = 2 SELECT Score, COUNT(Score) FROM Posts WHERE Posts.OwnerUserId = @UserId AND Posts.PostTypeId = @AnswerPostTypeId AND Score >= 0 AND Score <= 10 GROUP BY Score ORDER BY Score DESC