Most likely unanswered tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

WITH Raw AS (
  SELECT
    MIN(Tags.TagName) AS TagName,
    Tags.Id AS TagId,
    COUNT(*) AS AllQ,
    COUNT(CASE WHEN AnswerCount > 0 THEN 1 END) AS AnsweredQ
  FROM Tags, PostTags, Posts
  WHERE
    Tags.Count >= ##MinCount:int?100##
    AND
    PostTags.TagId = Tags.Id
    AND
    Posts.Id = PostTags.PostId
  GROUP BY Tags.Id
)
SELECT
  *,
  100.0 - (100.0 * AnsweredQ / AllQ) AS PUnanswered
FROM Raw
ORDER BY PUnanswered DESC, TagId

Enter Parameters

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