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