Q&A about the site for members of the workforce navigating the professional setting
SELECT TOP 10 q.Id, q.Title, q.CreationDate as QuestionDate, q.Tags, q.AnswerCount, a.CreationDate as AnswerDate FROM Posts q JOIN Posts a ON a.Id = ( SELECT TOP 1 ap.Id FROM Posts ap WHERE ap.ParentId = q.Id ORDER BY ap.CreationDate ) WHERE q.CreationDate > Convert(datetime, '2016-12-31' )