Scores Graph (0 - 10)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results