Q&A about the site for people who use Blender to create 3D graphics, animations, or games
SELECT TOP ##TopN:int?100## Posts.OwnerUserId AS [User Link], COUNT(DISTINCT Posts.Id) AS Posts, COUNT(*) - COUNT(CASE WHEN Votes.VoteTypeId = 3 THEN 1 END) AS Ups, COUNT(CASE WHEN Votes.VoteTypeId = 3 THEN 1 END) AS Downs, 100.0 * COUNT(CASE WHEN Votes.VoteTypeId = 3 THEN 1 END) / COUNT(*) AS DownPct FROM Posts, Votes WHERE Votes.PostId = Posts.Id AND Votes.VoteTypeId BETWEEN 2 AND 3 AND Posts.OwnerUserId > 0 GROUP BY Posts.OwnerUserId HAVING COUNT(DISTINCT Posts.Id) >= ##MinPosts:int?10## ORDER BY DownPct DESC, Posts.OwnerUserId