Time to answer questions, by tag.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select
  Asked,
  TagName,
  count(*) Questions,
  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 > '2015-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 ('tensorflow', 'pytorch')
group by
  Asked,
  TagName
order by 
  AvgHoursToAnswer

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results