Q&A for professional mathematicians
SELECT t.TagName, t.[Count] AS '# of questions', ROUND(100.0 * (t.[Count] - COUNT(*)) / t.[Count], 2) AS '% downvoted' FROM Tags AS t INNER JOIN PostTags AS pt ON t.Id = pt.TagId LEFT OUTER JOIN Votes AS v ON v.PostId = pt.PostId AND v.VoteTypeId = 3 -- downvotes WHERE t.[Count] >= ##MinTagCount:int?1000## AND v.PostId IS NULL -- so we select the questions WITHOUT downvotes GROUP BY t.TagName, t.[Count] ORDER BY ROUND(100.0 * (t.[Count] - COUNT(*)) / t.[Count], 2) DESC