All Users Ranked by Total Votes and Percent DVs

1

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

SELECT
u.Id AS [User Link],
(u.UpVotes + u.DownVotes) AS 'Total Votes',
CASE
WHEN ((u.UpVotes + u.DownVotes) > 0) THEN
    ROUND(
      CAST(u.DownVotes AS Float) / (u.UpVotes + u.DownVotes) * 100
    , 4)
  ELSE
    0
  END
 AS '% DV'
FROM Users u
WHERE (u.Reputation >= 125 OR u.DownVotes > 0) AND u.Id <> -1
ORDER BY 'Total Votes' DESC, '% DV' DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results