Close count per tag with close rate >= 10%

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists 100 tags with close rate >= 10% (to weed out the legit tags like [php] with lots of closed questions) Ordered by number of closed questions (descending) to emphasize tags' significance These tags are possibly problematic, but sometimes just misapplied A modification of http://data.stackexchange.com/stackoverflow/s/1266/per-tag-close-rate

Computational Science

Q&A for scientists using computers to solve scientific problems

-- Close count per tag with close rate >= 10%
-- Lists 100 tags with close rate >= 10% (to weed out the legit tags like [php] with lots of closed questions)
-- Ordered by number of closed questions (descending)
-- A modification of http://data.stackexchange.com/stackoverflow/s/1266/per-tag-close-rate

SELECT TOP 100
    TagName as [Tag],
    COUNT(*) [Total Posts],
    100.0 * COUNT(ClosedDate) / count(*) as [Close Rate],
    COUNT(ClosedDate) [Closed Posts]
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
and (100.0 * COUNT(ClosedDate) / count(*)) >= 10
ORDER BY COUNT(ClosedDate) desc

Enter Parameters

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