Most unanswered tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

SELECT TOP 500
    TagName AS [Tag],
    UnansweredCount AS [Unanswered],
    AnsweredCount AS [Answered],
    ((100.0 * UnansweredCount) / (UnansweredCount + AnsweredCount)) AS [% unanswered]
FROM (
    SELECT 
        TagName,
        SUM(CASE
            WHEN Post.AnswerCount > 0 THEN 1
            ELSE 0
        END) AS AnsweredCount,
        SUM(CASE
           WHEN Post.AnswerCount = 0 THEN 1
           ELSE 0
        END) AS UnansweredCount
    FROM
        Tags AS Tag
        INNER JOIN PostTags AS PostTag ON
            PostTag.TagId = Tag.Id
        INNER JOIN Posts AS Post ON
            Post.Id = PostTag.PostId
    WHERE
        Post.Score >= 0
        AND
        Post.ClosedDate IS NULL
    GROUP BY
       Tag.TagName
) As TagStatistics
WHERE
    --AnsweredCount > 0    AND
    UnansweredCount > 0
ORDER BY
    ((100.0 * UnansweredCount) / (UnansweredCount + AnsweredCount)) DESC

Enter Parameters

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