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
  eomonth(CreationDate),
  COUNT(Id) AS [All Votes],
  SUM(Case When VoteTypeId=2 Then 1 Else 0 End) AS UpVotes,
  SUM(Case When VoteTypeId=3 Then 1 Else 0 End) AS DownVotes
FROM PostFeedback
WHERE (CreationDate >= '##Date1?2015-01-01##') AND (CreationDate <= '##Date2?2025-01-01##')
GROUP BY eomonth(CreationDate)
ORDER BY eomonth(CreationDate)

fork query

created apr 29 Martin20528