Per Tag Close Rate

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lists 100 tags with a high close rate and at least 5 closed questions. These tags are "probably" bad tags.

Stack Overflow

Q&A for programmers

-- Per Tag Close Rate
-- Lists a selection of tags with a high close rate.
SELECT TOP 100
    TagName as [Tag],
    COUNT(*) [Total Posts],
    COUNT(ClosedDate) [Closed Posts],
    100.0 * COUNT(ClosedDate) / count(*) as [Close Rate]
FROM Tags
JOIN PostTags ON Tags.Id = PostTags.TagId
JOIN Posts ON Posts.Id = PostTags.PostId
GROUP BY TagId, TagName
HAVING COUNT(ClosedDate) >= 5 -- give the tag a chance to be useful
ORDER BY 100.0 * COUNT(ClosedDate) / COUNT(*) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached