Distribution of users' up/down cast votes

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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

SELECT
Id as [User Link],
UpVotes+DownVotes as TotalVotes,
UpVotes,
DownVotes,
round ( 100*UpVotes / ( UpVotes + DownVotes + 0.1 ), 0) AS 'UpVotes [%]'
FROM Users U

Where UpVotes + DownVotes > 100
 
ORDER BY
  'UpVotes [%]' ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results