Q&A about the site for members of the workforce navigating the professional setting
SELECT questions.Id as [Post Link], questions.title, questions.body, answers.body, questions.viewcount,questions.Tags, questions.Score,answers.Score,questions.AnswerCount, questions.LastActivityDate,questions.AcceptedAnswerId, questions.CommentCount, questions.FavoriteCount, questions.LastEditorUserId, questions.LastEditorDisplayName, questions.LastEditDate, questions.CreationDate, questions.ClosedDate FROM Posts questions left JOIN Posts answers ON answers.parentid = questions.id where year(questions.CreationDate) < 2015 order by questions.CreationDate DESC