Most controversial post on Stackoverflow

0

Please login or register to vote for this query.

(click on this box to dismiss)

Selects all posts where the number of upvotes is greater than the number of downvotes, but where the number of downvotes is at least half the number of upvotes. The result is ordered by the number of upvotes (the highest on top).

Stack Overflow

Q&A for professional and enthusiast programmers

select concat('https://stackoverflow.com/a/', PostId), Upvotes, Downvotes
from (
    select PostId, Upvotes, Downvotes, 2 * Downvotes / nullif(Upvotes, 0) as Ratio
    from (
        select
            PostId, 
            Upvotes = sum(case when VoteTypeId = 2 then 1 else 0 end),
            Downvotes = sum(case when VoteTypeId = 3 then 1 else 0 end)
        from Votes
        where VoteTypeId in (2,3)
        group by PostId
    ) as VoteCounts inner join Posts on Posts.Id = VoteCounts.PostId
    where Upvotes > 0 and Downvotes > 0
) as Scores
where Ratio >= 1
order by Upvotes desc

Enter Parameters

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