0

Please login or register to vote for this query.

(click on this box to dismiss)

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
from 
(
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

fork query

edited dec 27 15

created dec 26 15 Jeremy.Lewi