Estimate number of removed/changed votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

History

Q&A for historians and history buffs

select count(id) as NumberExistingVotes,
       sum( case when VoteTypeId in (2,3) then 1 else 0 end) as PostVotes,
       max(id) as TotalVotes ,
       1-1.00* sum( case when VoteTypeId in (2,3) then 1 else 0 end)/(sum( case when VoteTypeId in (2,3) then 1 else 0 end)+max(id)-count(id)) as RatioRemoved
from Votes

Enter Parameters

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