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
min(a.CreationDate) - q.CreationDate TimeToAnswer
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