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)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

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 main site
loading Hold tight while we fetch your results