Q&A for active researchers, academics and students of physics
cast(DATEPART(YYYY, p3.CreationDate) as varchar) + '-' + cast(DATEPART(MM, p3.CreationDate) as varchar) + '-01'
as datetime) [Month],
1 as ccomment
, p3.id as [Post Link]
from Posts p3 inner join comments c on c.postid=p3.id where p3.posttypeid=1 and p3.closeddate !='' and c.text like '%engineering%'
order by [Month] desc