question3parta

0

Please login or register to vote for this query.

(click on this box to dismiss)

DevOps

Q&A for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

select AVG(CAST(DATEDIFF(ss,A.CreationDate,B.CreationDate) as Float)) as AvgAnswerInSecs 
from Posts A, PostTypes PT, Posts B
where YEAR(A.creationdate) = 2017
and A.AcceptedAnswerId is not null
and A.DeletionDate is null
and A.PostTypeId = PT.Id
and PT.Name = 'Question'
and B.id = A.AcceptedAnswerId

Enter Parameters

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