Breaks down average time to answer questions by tag, across time.
Filters out unanswered and questions answered after 30 days.
Q&A for professionals, academics, and students working within the systems development life cycle
-- count(*) Questions,
avg(cast(SecondsToAnswer as float))/60.0/60.0 AvgHoursToAnswer,
stdev(cast(SecondsToAnswer as float))/60.0/60.0 StdevHoursToAnswer
dateadd(d, - datepart(d, q.CreationDate) + 1, Convert(Date, q.CreationDate)) 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.CreationDate between '2013-01-01' and '2017-12-31'
and q.PostTypeId = 1
and a.PostTypeId = 2
and a.Score >= 10
TagName in ('c#','java','collision-detection','camera','textures','client-server','physics')
-- order by