Total given downvotes, grouped by floor(log2(Rep))

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT
  FLOOR(LOG(1.0 * Reputation) / LOG(2.0)) AS Log2Rep,
  SUM(DownVotes) AS DownVotes
FROM Users
WHERE
  DownVotes > 0
  AND
  Id > 0
  AND
  Reputation > 1
GROUP BY FLOOR(LOG(1.0 * Reputation) / LOG(2.0))
ORDER BY Log2Rep

Enter Parameters

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