Most downvoted users

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 users in total downvotes received.

Statistical Analysis

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

select top 500 C.id as [User Link], sum(D.downvotes) as downvotessum,
round(cast(nullif(sum(D.downvotes), 0)as float) / C.Reputation ,4) as ratios,
C.Reputation as rep
from Users as C inner join (
  select A.id as postId, A.ownerUserId as userId, 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 D
on C.id = D.userId
group by C.id, C.Reputation
order by C.Reputation desc

Enter Parameters

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