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