SELECT AVG(CAST(DATEDIFF(ss, p.CreationDate, a.CreationDa...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Patents Meta

Q&A about the site for people interested in improving and participating in the patent system

SELECT
  AVG(CAST(DATEDIFF(ss, p.CreationDate, a.CreationDate) AS float)),
  COUNT(CAST(DATEDIFF(ss, p.CreationDate, a.CreationDate) AS float)),
  SUM(CAST(DATEDIFF(ss, p.CreationDate, a.CreationDate) AS float))
FROM
    Posts p
  INNER JOIN
    Posts a ON p.AcceptedAnswerId = a.Id
WHERE
  p.CreationDate BETWEEN '2017-01-01' AND '2017-12-31'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results