Average answer time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

select avg(cast(ResponseTime as bigint)) as Average,
       stdev(cast(ResponseTime as bigint)) as StandardDev
from
  (select
         Questions.CreationDate,
         Questions.Title,
         Tags.TagName,
         Answers.CreationDate as ResponseDate,
         datediff(hour, Questions.CreationDate, Answers.CreationDate) as ResponseTime,
         cast(DATEPART(hour, Questions.CreationDate) as int) as ResponseHour
    from Posts Questions
    join Posts Answers on Answers.id = Questions.AcceptedAnswerId
        and datediff(hour, Questions.CreationDate, Answers.CreationDate) > 6
    join PostTags ON PostTags.PostId = Questions.Id
    join Tags on Tags.Id = PostTags.TagId
    where Questions.CreationDate > convert(datetime, '01/01/2012', 101)
          
) as Responses

Enter Parameters

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