0

Please login or register to vote for this query.

(click on this box to dismiss)

Users with the most downvotes cast on their questions and answers

プログラマーとプログラミングに熱心な人々のための質問と回答

SELECT TOP 25
  b.OwnerUserId AS [User Link],
  SUM(CASE WHEN a.VoteTypeId = 3 THEN 1 ELSE 0 END) * 100 / COUNT(a.VoteTypeId) AS PctDownVotes,
  COUNT(DISTINCT b.Id) AS NumberOfPosts
FROM Votes a
  INNER JOIN Posts b
    ON 
      a.PostId = b.Id
GROUP BY b.OwnerUserId
HAVING COUNT(DISTINCT b.Id) > 10
ORDER BY  PctDownVotes ASC

fork query

edited jul 24 12 anonymous

created mar 27 12 jadarnel27