Votes / posts ration per month

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 Year = DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0), 
  Votes = SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE -1 END), 
  Posts = (SELECT COUNT(id) 
           FROM Posts
           WHERE CreationDate >= Convert(datetime, '2011-07-01' )
           GROUP BY DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0))
FROM PostFeedback
group by DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0)
order by DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0)*/

Select * from Posts;

select * from Votes;

Enter Parameters

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