0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language

SELECT TOP 100 
         P1.Id
       , P1.PostTypeId
       , P1.Body
       , P1.AcceptedAnswerId
       , P1.CreationDate
       , P2.Id
       , P2.PostTypeId
       , P2.Body
       , P2.CreationDate
       , DATEDIFF(minute,P2.CreationDate,P1.CreationDate) ResponseTime
  FROM Posts P1, Posts P2
  WHERE YEAR(P1.CreationDate) = 2017
      AND P1.PostTypeId = 1
      AND P2.PostTypeId = 2 
      AND P1.AcceptedAnswerId = P2.Id

fork query

edited jan 15 22

created jan 15 22 anonymous