Histogram of time to first answer


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 hours_to_first_answer, count(*) as answer_count from
select qId, min(hours_to_answer) as hours_to_first_answer from 
(select questions.Id as qId, questions.CreationDate as qCreationDate, answers.Id as aId, answers.CreationDate as aCreationDate, DATEDIFF(hour, questions.CreationDate, answers.CreationDate) as hours_to_answer
select * from Posts where PostTypeId=1 and Id in (select PostId from PostTags where TagId=108024)
) questions
inner join 
select * from Posts where PostTypeId=2 and ParentId in (select PostId from PostTags where TagId=108024)
) answers on questions.Id = answers.ParentId) qa group by qId
) latency 
group by hours_to_first_answer
order by hours_to_first_answer

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results