Correlation Between Qnt Votes and %DVs at >1000 Votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mythology Meta

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT
(u.UpVotes + u.DownVotes) AS 'Total Votes',
CAST(u.DownVotes AS Float) / (u.UpVotes + u.DownVotes) * 100 AS '% DV'
FROM Users u
WHERE (u.Reputation >= 125 OR u.DownVotes > 0) 
  AND (u.UpVotes + u.DownVotes) > 20000 
  --AND (u.UpVotes + u.DownVotes) < 20000 
  AND u.Id <> -1
ORDER BY 'Total Votes' DESC, '% DV' DESC

Enter Parameters

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