instruction: (EXAMPLE #2) Time to First Answer (Link to Q using [Post Link]).
response: SELECT q.Id AS "qid", q.Id AS "post_link", q.CreationDate AS "question_date", MIN(a.CreationDate) AS "1st_answer_date", DATEDIFF(n, q.CreationDate, MIN(a.CreationDate)) AS "min_to_1st_answer" FROM Posts AS q LEFT OUTER JOIN Posts AS a ON q.Id = a.ParentId WHERE q.PostTypeId = 1 AND (a.PostTypeId = 2 OR a.PostTypeId IS NULL) AND q.DeletionDate IS NULL AND a.DeletionDate IS NULL AND q.ClosedDate IS NULL AND a.ClosedDate IS NULL AND q.CreationDate >= DATEADD(d, 30, GETDATE()) GROUP BY q.Id, q.CreationDate ORDER BY q.CreationDate