instruction: Average wait time for question being answered based on hour of asking.
response: SELECT TIME_TO_STR(QuestionWithT.CDate, '%-HOUR') AS AskingHour, AVG(QuestionWithT.T) AS AvgWaitTimeForFirstResponse FROM (SELECT Question.Id AS Id, MIN(Question.CreationDate) AS CDate, MIN(CAST((JULIANDAY(CreationDate) - JULIANDAY(Question.CreationDate)) * 1440.0 AS INT)) / (24.0 * 60) AS T FROM Posts AS Question, Posts AS Answer WHERE Answer.ParentId = Question.Id AND Question.PostTypeId = 1 AND Answer.PostTypeId = 2 GROUP BY Question.Id) AS QuestionWithT GROUP BY TIME_TO_STR(QuestionWithT.CDate, '%-HOUR')