How much downvotes get deleted

0

Please login or register to vote for this query.

(click on this box to dismiss)

Total downvotes that have been given (sum downvotes from users). Plus total downvotes that are not deleted (by summing downvotes over posts that actually still exist)

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

select 
(select sum(B.downvotes) from Posts as A inner join (  
    select postId, count(*) as downvotes
    from Votes
    where voteTypeId = 3
    group by postId
  ) as B
  on A.id = B.postId) as "non deleted votes", 
(select sum(Downvotes) from Users) as "total votes"

Enter Parameters

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