1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

WITH Totals_CTE AS (
  SELECT
    SUM(UpVotes) TotalUpVotes,
    SUM(DownVotes) TotalDownVotes
  FROM Users
  WHERE
    Reputation > ##RepThreshold:int##
    AND DownVotes > 0
    AND (UpVotes + DownVotes) > ##VoteThreshold:int##
)
SELECT
  Id as [User Link],
  ROUND(1.0 * UpVotes / DownVotes, 2) Ratio,
  Reputation,
  UpVotes,
  DownVotes,
  FORMAT(1.0 * UpVotes / (SELECT TotalUpVotes FROM Totals_CTE), 'P') [UpVote%Share],
  FORMAT(1.0 * DownVotes / (SELECT TotalDownVotes FROM Totals_CTE), 'P') [DownVote%Share]
FROM Users
WHERE
  Reputation > ##RepThreshold:int##
  AND DownVotes > 0
  AND (UpVotes + DownVotes) > ##VoteThreshold:int##
ORDER BY (UpVotes + DownVotes) DESC;

fork query

edited jan 11 gronostaj

created jan 11 anonymous