Breaks down average time to answer questions by tag, across time.
Filters out unanswered and questions answered after 30 days.
Q&A about the site for administrators, end users, developers and designers for Craft CMS
format(q.CreationDate, 'yyyy-MM-dd') Asked,
datediff(second, q.CreationDate, min(a.CreationDate)) SecondsToAnswer
from Posts q
inner join PostTags pt on q.Id = pt.PostId
inner join Tags t on pt.TagId = t.Id
inner join Posts a on q.Id = a.ParentId
q.PostTypeId = 1
and a.PostTypeId = 2
where SecondsToAnswer < 2592000
group by TagName, Asked
order by TagName, Asked