0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of Apple hardware and software

SELECT t.TagName AS Tag, COUNT(p.Id) AS "Post count",
ROUND(SUM(CASE WHEN p.AnswerCount = 0 THEN 1 ELSE 0 END) * 100.0 /COUNT(1),2) AS [Percent with no answer]
FROM Posts p
INNER JOIN PostTags pt ON p.Id = pt.PostId
INNER JOIN Tags t ON pt.TagId = t.Id
WHERE p.PostTypeId = 1 --questions
GROUP BY t.Id, t.TagName
HAVING COUNT(p.Id) > 100000
ORDER BY [Percent with no answer] DESC

fork query

edited aug 11 22

created mar 1 13 anonymous