0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jan 21 15

created jan 21 15 Shadow Wizard