0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

SELECT Avg(rt.responsetime)
FROM   (SELECT q.id,
               q.creationdate,
               Datediff(second, q.creationdate, a.creationdate) / 3600.0 AS
                      responsetime
        FROM   posts AS q
               INNER JOIN posts AS a
                       ON q.acceptedanswerid = a.id
        WHERE  q.creationdate <= '2021-12-05T05:26:09.073'
               AND q.creationdate >= '2018-01-16T12:00:00.000') AS rt;

fork query

edited jan 16 22

created jan 16 22 anonymous