0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited mar 22 18

created mar 22 18 Glorfindel