Q&A about the site for members of the workforce navigating the professional setting
SELECT p.Id , p.Title , p.Tags , P.AnswerCount ,p.AcceptedAnswerId ,P.CreationDate ,p. ViewCount , p.Body ,a.Body ,t.TagName FROM Posts p JOIN Posts a ON p.AcceptedAnswerId = a.Id -- to get bot question and answer JOIN PostTags pt ON pt.PostId=p.Id JOIN Tags t on t.Id =pt.TagId WHERE p.PostTypeId=1 AND p.Title like '%regression' -- AND p.AcceptedAnswerId not null -- AND t.TagName like '%C++%'