Time to Answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Breaks down average time to answer questions by tag, across time. Filters out unanswered and questions answered after 30 days.

Music Fans Meta

Q&A about the site for music historians, critics, and fans

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 > '2013-11-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', 'php', 'python')
group by
  Asked
--  TagName
order by 
  Asked

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results