0

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas para programadores y profesionales de la informática

SELECT t.TagName AS Tag, month(creationDate), year(creationDate),
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)

fork query

edited oct 16 13

created mar 1 13 anonymous