0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- Enter Query Title
-- Enter Query Description
select DateDiff(minute, SQ.QuestionDate, SQ.AnswerDate) As Diff
FROM
(
select Questions.Id, Questions.CreationDate as QuestionDate, 
        MIN(Answers.CreationDate) as AnswerDate 
from Posts as Questions
inner join Posts as Answers on Questions.Id = Answers.ParentId
where Questions.PostTypeId = 1
Group By Questions.Id, Questions.CreationDate
) As SQ
ORDER BY Diff

fork query

created jan 14 11 anonymous