Controversial questions

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 PostId as [Post Link], Score, count(*) downvotes
from Posts q
     join Votes on PostId = q.Id
where PostTypeId = 1
      and VoteTypeId in (3)
      and ViewCount > 1000
      and Score between 1 and 9
group by PostId, Score
having count(*) > 9
order by Score, count(*) desc

Enter Parameters

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