0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT TOP 100 
  P.Title, 
  P.Id,
  DATEDIFF(second, P.CreationDate, A.CreationDate) SecondsToAnswer
FROM Posts P
INNER JOIN Posts A ON A.Id = P.AcceptedAnswerId
WHERE 
      P.ClosedDate IS NULL
  AND P.AnswerCount > 0
  AND DATEDIFF(second, P.CreationDate, A.CreationDate) > 0
  --Added this to prevent results showing answers earlier
  --than thee questions
ORDER BY SecondsToAnswer DESC

fork query

edited jun 29 12 BuildStarted

created jun 29 12 anonymous