Anonymous feedback votes over time

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

Select DATEADD(mm, (Year(CreationDate) - 1900) * 12 + Month(CreationDate) - 1, 0) As [Month],  
	Case VoteTypeId When 2 Then 'Upvotes' When 3 Then 'Downvotes' End As [Vote Type], 
    Count(Id) As Votes
From PostFeedback
Group By Year(CreationDate), Month(CreationDate), VoteTypeId
Order By Year(CreationDate), Month(CreationDate), VoteTypeId

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results