instruction: Questions that got an answer after they got closed. http://meta.stackexchange.com/questions/261039/how-often-questions-get-answered-after-they-got-closed
response: SELECT q.Id AS "post_link", q.ClosedDate, a.Id AS "post_link", a.CreationDate, CAST((JULIANDAY(CreationDate) - JULIANDAY(q.ClosedDate)) AS INT) AS "minutes", CAST((JULIANDAY(CreationDate) - JULIANDAY(q.ClosedDate)) AS INT) AS "seconds" FROM Posts AS q INNER JOIN Posts AS a ON a.ParentId = q.Id WHERE q.PostTypeId = 1 AND a.PostTypeId = 2 AND NOT q.ClosedDate IS NULL AND a.CreationDate > q.ClosedDate AND q.Id NOT IN (SELECT PostId FROM PostHistory WHERE PostHistoryTypeId = 10 GROUP BY PostId HAVING COUNT(*) > 1) ORDER BY CAST((JULIANDAY(CreationDate) - JULIANDAY(q.ClosedDate)) AS INT) DESC