0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

WITH Answers AS (
    SELECT Posts.CreationDate, Posts.Id
    FROM Posts
    JOIN PostTypes on Posts.PostTypeId = PostTypes.Id
    WHERE Posts.CreationDate BETWEEN '2017-01-01' AND '2017-12-31' 
      AND PostTypes.Id = 2
)

SELECT Posts.CreationDate, Posts.Id, Answers.Id
FROM Posts

JOIN Answers on Posts.AcceptedAnswerId = Answers.Id

fork query

edited aug 3 21

created aug 2 21 anonymous