Average time to Answer a question


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for Joomla! administrators, users, developers and designers

SELECT p1.id      AS "AnsID",
  p1.ParentId     AS "QuestionId",
  p1.Creationdate AS "AnsCreationdate",
  p2.Creationdate AS "QuestionCreationdate",
  DATEDIFF(minute, p2.Creationdate, p1.Creationdate) AS Time_Difference
FROM posts p1
JOIN posts p2
ON p1.ParentId     = p2.Id
WHERE p1.PostTypeId=2
AND p1.parentid   IN
  (SELECT pq.id
  FROM posts pq ,
    users u
  WHERE pq.owneruserid= u.id
  AND pq.PostTypeId   =1
  AND pq.tags in ('c#') 
  AND pq.CreationDate BETWEEN '2013-01-01 00:00:00' AND '2017-12-31 23:59:59');

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results