SqlServer統計表中某年某月某個值有多少？

 　　比如：統計表AA中YWLX列在某年某月每種類型各有多少?
?

1 2 3 4 5 6 select year(AA_YWRQ) as YEARS,   month(AA_YWRQ) AS Months ,AA_YWLX,count(AA_YWLX) as Number from  AA group by year(AA_YWRQ),   month(AA_YWRQ),AA_YWLX

　　表中數據：

　　查詢後的結果：