2

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the top 40 tags, how many times they're used each, and how many questions are needed with that tag so that the Site is eligible for the Generalist badge

Q&A for linguists, etymologists, and serious English language enthusiasts

-- Is the site ready for the Generalist Badge?
-- Lists the top 40 tags, how many times they're used each, and how many questions are needed with that tag so that the Site is eligible for the Generalist badge

SELECT TOP 40 TagName, COUNT(p.TagId) as 'Uses', 200-Count(p.TagId) as 'Questions Needed with this Tag Left'
FROM Tags t
INNER JOIN PostTags p
ON p.TagId = t.Id
GROUP BY t.TagName
ORDER BY Uses DESC

fork query

created sep 15 10 anonymous