Number of downvotes by question score

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 p.Score as [Score], Count(v.Id) as [Downvotes] from Votes v 
inner join Posts p 
on p.Id=v.PostId 
where p.PostTypeId = 1 AND v.VoteTypeId = 3 
group by p.Score 
order by p.Score

Enter Parameters

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