SELECT TOP 40 TagName, COUNT(p.TagId) as 'Uses', 200-Coun...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

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
WHERE t.TagName = 'fun'
GROUP BY t.TagName
ORDER BY Uses DESC

Enter Parameters

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