Upvotes/Downvotes per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

for Tall Jeff

The Workplace Meta

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

-- Upvotes/Downvotes per month
-- for Tall Jeff

select
  datepart(year, CreationDate) Year,
  datepart(month, CreationDate) Month,
  count(*) Count,
  count(distinct UserId) DistinctCount
from Votes where VoteTypeId in (2,3)
group by datepart(year, CreationDate), datepart(month, CreationDate)
order by datepart(year, CreationDate), datepart(month, CreationDate)

Enter Parameters

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