1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT year(CreationDate) as year, 
  count(iif(VoteTypeId = 2, Id, null)) as Up, 
  count(iif(VoteTypeId = 3, Id, null)) as Down,
  count(iif(VoteTypeId = 1, Id, null)) as Accept
FROM Votes 
WHERE year(CreationDate) >= 2010 AND year(CreationDate) < year(GETDATE())
GROUP BY year(CreationDate) ORDER BY year

fork query

edited jan 30 23 Rubén

created aug 7 19 jon.doe31917