Q&A for spacecraft operators, scientists, engineers, and enthusiasts
SELECT C.ApprovalDate, P.CreationDate FROM Posts P LEFT JOIN CloseAsOffTopicReasonTypes C on P.Id = C.Id WHERE datepart(yyyy, P.CreationDate) = 2017 ;