% downvoted questions per tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results