SELECT q.Title, q.CreationDate AS Asked, a.CreationDate ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

Q&A for speakers of other languages learning English

-- Enter Query Title
-- Enter Query Description

SELECT
  --q.Id,
  q.Title,
  q.CreationDate AS Asked,
  --a.Id,
  a.CreationDate AS Answered,
  a.CreationDate - q.CreationDate AS lag
FROM
  Posts AS q JOIN Posts AS a ON a.ParentId = q.Id
WHERE
    a.OwnerUserId = 121096
    AND a.PostTypeId = 2
    AND a.Score >= 5
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results