select SQ.Id as [PostId], DateDiff(minute, SQ.QuestionDat...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

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

select SQ.Id as [PostId], 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
and Questions.OwnerUserId = ##USERID##
Group By Questions.Id, Questions.CreationDate
) As SQ
ORDER BY Diff

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results