0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to improve their interpersonal communication skills

--Querying Posts that contain "architecture" term 
-- and Comments with contain "useful" or "helpful"

select top 1000 p.Id as [Post Link],p.Title,p.Tags,p.body, p.Score as "Questions Score",
a.Score AS "Answer Accepted Score" ,c.Id as [Comment Link],c.Text
from Posts p
JOIN Posts a ON p.AcceptedAnswerId = a.Id
JOIN Comments c ON p.Id = c.PostId
where (p.body like '%architect%' or p.Title like '%architect%')
and
(c.Text like '%useful%' or c.Text like '%helpful%')  and p.AnswerCount <>0

fork query

edited jan 25 20

created jan 21 20 Musenga