Distribution of users' up/down cast votes: graph

1

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- 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 to main site
loading Hold tight while we fetch your results