0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for artists and crafters

SELECT InitialPost.CreationDate, AnswerPosts.CreationDate, 
  DateDiff(Minute, AnswerPosts.CreationDate, InitialPost.CreationDate)
FROM Posts InitialPost, Posts AnswerPosts
WHERE InitialPost.AcceptedAnswerId IS NOT NULL 
  AND InitialPost.AcceptedAnswerId = AnswerPosts.Id
  AND Year(InitialPost.CreationDate) = 2017

fork query

edited oct 15

created oct 13 anonymous