3

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.

Q&A for anime and manga fans

-- 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

fork query

created apr 25 11 Brian Reichle