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 physical fitness professionals, athletes, trainers, and those providing health-related needs
select Asked, TagName, --avg(cast(SecondsToAnswer as float))/60.0/60.0 AvgHoursToAnswer, stdev(cast(SecondsToAnswer as float))/60.0/60.0 StdevHoursToAnswer from ( select t.TagName, dateadd(d, - datepart(d, q.CreationDate) + 1, Convert(Date, q.CreationDate)) Asked, min(a.CreationDate) AnswerDate, 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 where q.CreationDate > '2011-01-01' and q.PostTypeId = 1 and a.PostTypeId = 2 and datediff(second, q.CreationDate, a.CreationDate) < 2592000 -- 30 days group by t.TagName, q.CreationDate ) q where TagName in ('c#', 'java', 'javascript', 'obj-c', 'ios') group by Asked, TagName order by Asked