Q&A for people looking to improve their interpersonal communication skills
(select PostTypeId, sum(case when datepart(quarter,a.CreationDate) = 2 and datepart(quarter,a.LastEditDate) = 2 then 1 else 0 end) as REJECT_CNT, sum(case when datepart(quarter,a.CreationDate) = 2 then 1 else 0 end) as SUBMIT_CNT from posts a group by PostTypeId)