select q.CreationDate as QuestionCreationDate, a.Creatio...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

-- Enter Query Title
-- Enter Query Description

select 
    q.CreationDate as QuestionCreationDate,
    a.CreationDate as AnswerCreationDate,
    cast (a.CreationDate as float) - q.CreationDate as TimeToAnswer
from 
    Posts as a
        inner join Posts as q on q.Id = a.ParentId
where
    --- Post type answer.
    a.PostTypeId = 2 and
    --- User casperOne
    a.OwnerUserId = 50776 and
    --- No other answers
    not exists (
        select * from Posts where ParentId = q.Id and Id <> a.Id
    )
order by 3 desc

Enter Parameters

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