Teahouse question response time

This query is marked as a draft This query has been published by Jmorgan (WMF).

Last run September 28, 2016
How many minutes, on average, between a Teahouse question and the first answer?

SQL

use p50380g50728__hostbot_p;

select AVG(mins) 
from (
  select TIME_TO_SEC(TIMEDIFF(first_answer_date, post_date))/60 as mins 
  	from th_up_questions 
  where first_answer_date IS NOT NULL
	) as tmp;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...