Q&A about the site for Joomla! administrators, users, developers and designers
select [Month], Questions, Answers from ( select [Month], sum(case when PostTypeId = 1 then 1 else 0 end) as Questions, sum(case when PostTypeId = 2 then 1 else 0 end) as Answers from ( select CAST( cast(DATEPART(YYYY, CreationDate) as varchar) + '-' + cast(DATEPART(MM, CreationDate) as varchar) + '-01' as datetime) [Month], PostTypeId from Posts p ) as X group by [Month] ) as Y order by [Month] asc