Critics - Reputation vs DownVotes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached