WITH QuestionAndAnswer AS ( SELECT q.Id AS QuestionId, q....

0

Please login or register to vote for this query.

(click on this box to dismiss)

User Experience Meta

Q&A about the site for user experience researchers and experts

WITH QuestionAndAnswer AS (
    SELECT
        q.Id AS QuestionId,
        q.CreationDate AS QuestionCreationDate,
        a.Id AS AnswerId,
        a.CreationDate AS AnswerCreationDate
    FROM Posts q
    JOIN Posts a ON q.Id = a.ParentId
    WHERE q.PostTypeId = 1
    AND a.PostTypeId = 2
)
SELECT * FROM QuestionAndAnswer
WHERE AnswerCreationDate - QuestionCreationDate BETWEEN -5 AND 5;

Enter Parameters

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