0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited aug 25 20

created aug 25 20 Maciej Kowalski