Most-closed Tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

This query orders tags by the number of closed (and non-deleted, obviously) questions as a percentage of total questions with that tag.

Mathematics

Q&A for people studying math at any level and professionals in related fields

SELECT
  t.TagName, 
  SUM(case when p.ClosedDate IS NOT NULL then 1 end) as [Number Closed],
  count(p.Id) as [Total Tagged]
FROM Tags AS t 
  INNER JOIN PostTags pt ON t.Id = pt.TagId
  INNER JOIN Posts P ON p.Id = pt.PostId
group by t.TagName
ORDER BY [Number Closed] DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results