Distribution of users' up/down cast votes: graph

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Apps

Q&A for apps, scripts, and development with the Stack Exchange API

-- Users cast votes: upvotes, downvotes and the ratio upvotes/downvotes
-- for each user with total cast votes > 100, graph

select

round ( 100*UpVotes / ( UpVotes + DownVotes + 0.1 ), 0) AS UpRatio,
count(*) AS N

FROM

(SELECT * FROM Users U Where U.UpVotes + U.DownVotes > 100) a

  
GROUP BY
 round ( 100*UpVotes / ( UpVotes + DownVotes + 0.1 ), 0)

 
ORDER BY
  UpRatio ASC

Enter Parameters

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