Q&A about the site for members of the workforce navigating the professional setting
SELECT questions.Id as [post_link], questions.title as [title], questions.body as [body_question], answers.body as [body_answer], questions.viewcount as [viewcount],questions.Tags as [tags], questions.Score as [score],answers.Score as [score_answer],questions.AnswerCount as [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 questions.Tags like '%<diffie-hellman>%' and questions.Tags not like '%<cryptography>%' order by questions.viewcount DESC