Select Season = Case when month(日期) in (1,2,3) then '一季度'
when month(日期) in (4,5,6) then '二季度'
when month(日期) in (7,8,9) then '三季度'
when month(日期) in (10,11,12) then '四季度' end ,
count(*)
from tablename
group by Case when month(日期) in (1,2,3) then '一季度'
when month(日期) in (4,5,6) then '二季度'
when month(日期) in (7,8,9) then '三季度'
when month(日期) in (10,11,12) then '四季度' end
查询结果为 按季度分组后的各季度记录数量