Q&A for professional and enthusiast programmers
count(1) as Count,
sum(A.HastriedComment) as TriedCount
case when C.Id is null then 0 else 1 end as HasTriedComment,
Posts as P
left join Comments as C on C.PostID = P.ID and C.Text like '%what have you tried%'
P.creationdate > '2013-02-15'
) as A