0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Ubuntu users and developers

-- Least answered tags (relative)
-- A list of tags sorted by ratio of posts without answers

SELECT TOP 100
    TagName AS [Tag],
    UnansweredCount AS [Unanswered],
    AnsweredCount AS [Answered],
    ((1.0 * UnansweredCount) / AnsweredCount) AS [U/A Ratio]
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 > 10
ORDER BY
    (UnansweredCount + AnsweredCount) DESC

fork query

created jun 4 laptop2d