Questions which change from negative rep to positive rep if upvote goes from 5 to 10

0

Please login or register to vote for this query.

(click on this box to dismiss)

Looks for posts with more than half the amount of downvotes as they have upvotes Ordered by upvotes

Programming Puzzles and Code Golf

Q&A for programming puzzle enthusiasts and code golfers

set nocount on 

declare @VoteStats table (PostId int, up int, down int) 

insert @VoteStats
select
    PostId, 
    up = sum(case when VoteTypeId = 2 then 1 else 0 end), 
    down = sum(case when VoteTypeId = 3 then 1 else 0 end)
from Votes
where VoteTypeId in (2,3)
group by PostId

set nocount off

select PostId as [Post Link], up, down, p.PostTypeId from @VoteStats
join Posts p on PostId = p.Id
where 5*up-2*down < 0 AND 10*up-2*down > 0 and p.PostTypeId = 1 /* question */

Enter Parameters

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