0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT u.Id, u.DisplayName, u.Reputation, u.DownVotes,
CONVERT(DECIMAL(10,2), CAST((u.Reputation + u.DownVotes) AS DECIMAL) / (u.DownVotes * 2)) as DownVoteRatio,
u.UpVotes,
u.Reputation + u.DownVotes as EffectiveReputation
FROM Users u
WHERE u.Reputation > 30000
AND u.DownVotes > 0
ORDER BY DownVoteRatio ASC

fork query

edited apr 30 14

created apr 29 14 Jarrod Roberson