SQL按月份分組、加總各月份資料

SELECT C.MarkName
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'1月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'2月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'3月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'4月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'5月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'6月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'7月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'8月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'9月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'10月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'11月'
,SUM(Case MONTH(AcceptDate) when '1' then '1' else 0 end) as'12月'
,COUNT(C.MarkName)as '總合'
FROM (SELECT * FROM CasePublicData ) C
where AcceptDate between '2010/1/1' and '2010/12/31'
group by C.MarkName
order by C.MarkName

MarkName是廠商名字、AcceptDate是受理日期