Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
select count(*) as QuestionCount, sum(A.TriedComments) as TriedCount from ( select sum(case when C.text like '%have you tried%' or c.text like '%you have tried%' then 1 else 0 end) as TriedComments, P.ID from Posts as P left join Comments as C on C.PostID = P.ID where P.posttypeid = 1 group by P.ID ) as A