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