Percentage answer rate per tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

SELECT t.TagName AS Tag,
ROUND(SUM(CASE WHEN AcceptedAnswerId IS NOT NULL THEN 1 ELSE 0 END) * 100.0 /COUNT(1),2) AS [Percent Answered]
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
and t.TagName='google-chrome-app'
GROUP BY t.Id, t.TagName, month(creationDate), year(creationDate)

Enter Parameters

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