Critics - Reputation vs DownVotes


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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.Reputation + u.DownVotes as EffectiveReputation
FROM Users u
WHERE u.Reputation > 30000
AND u.DownVotes > 0
ORDER BY DownVoteRatio ASC

Enter Parameters

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