Stack Exchange
log in help

Average time to first answer (parameterized)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Rewrite of http://data.stackexchange.com/codereview/query/211467/average-time-to-in-seconds-to-answer-a-question-by-language-tag in response to http://codereview.stackexchange.com/questions/58668/average-time-to-first-answer. See http://codereview.stackexchange.com/a/58679/9357 for an explanation.

Stack Overflow

Q&A for professional and enthusiast programmers

select Q.Id, max(Q.CreationDate), min(A.CreationDate)
from   Posts Q, Posts A 
where  Q.PostTypeId = 1
  and  Q.Id = A.ParentId
group by Q.Id;
view current version

Enter Parameters

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