Number of down votes on answers in past 30 days

0

Please login or register to vote for this query.

(click on this box to dismiss)

Home Improvement

Q&A for contractors and serious DIYers

SELECT COUNT(*) 
FROM Votes 
JOIN Posts
ON Votes.PostId = Posts.Id
WHERE Votes.VoteTypeId in (3) AND Votes.CreationDate >= DATEADD(DAY, -30, GETDATE()) AND Posts.PostTypeId IN (2)

Enter Parameters

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