select eomonth(creationdate) [month] , sum(case when vote...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

select eomonth(creationdate) [month]
, sum(case when votetypeid = 2 then 1 else 0 end) [upvote]
, sum(case when votetypeid = 3 then 1 else 0 end) [downvote]
from postfeedback pf
group by eomonth(creationdate) 
order by eomonth(creationdate)

Enter Parameters

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