SELECT * FROM (SELECT CAST(AVG(CAST(DATEDIFF(hour, q.Crea...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT * FROM (SELECT
  CAST(AVG(CAST(DATEDIFF(hour, q.CreationDate, a.CreationDate) AS float)) AS varchar) + ' hours'
   as dif
FROM
    Posts q
  INNER JOIN (
    SELECT
      ParentId, min(CreationDate) AS CreationDate
    FROM
      Posts
    GROUP BY
      ParentId
    ) a
  ON q.Id = a.ParentId)AS TopHalf

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results