SELECT DATEPART(QUARTER,日期字段) [季度],COUNT(*)  [SL ]FROM TABLE WHERE xxxxx GROUP BY DATEPART(QUARTER,日期字段)

-------------

SELECT (CASE WHEN DATEPART(QUARTER,日期字段)=1 THEN '第一季度' WHEN DATEPART(QUARTER,日期字段)=2 THEN '第二季度' WHEN DATEPART(QUARTER,日期字段)=3 THEN '第三季度'  ELSE '第四季度' END ) [季度],COUNT(*)  [SL ]FROM TABLE WHERE xxxxx GROUP BY DATEPART(QUARTER,日期字段)