instruction: Top x most downvoted questions. Shows the most downvoted answers (with at least 25 downvotes)
response: WITH A AS (SELECT p.Id AS "post_link", SUM(CASE WHEN v.VoteTypeId = 3 THEN 1 ELSE 0 END) AS downvotes FROM Posts AS p INNER JOIN Votes AS v ON v.PostId = p.Id WHERE p.PostTypeId = 1 GROUP BY p.Id) SELECT A.* FROM A ORDER BY downvotes DESC LIMIT 100