SELECT CASE WHEN SUBSTR(发货日期,6,5)>='12-26' OR SUBSTR(发货日期,6,5)<='01-25' THEN '第1季度'

     WHEN SUBSTR(发货日期,6,5)>='01-26' AND SUBSTR(发货日期,6,5)<='02-25' THEN '第1季度'

WHEN SUBSTR(发货日期,6,5)>='02-26' AND SUBSTR(发货日期,6,5)<='03-25' THEN '第1季度'

WHEN SUBSTR(发货日期,6,5)>='03-26' AND SUBSTR(发货日期,6,5)<='04-25' THEN '第2季度'

WHEN SUBSTR(发货日期,6,5)>='04-26' AND SUBSTR(发货日期,6,5)<='05-25' THEN '第2季度'

WHEN SUBSTR(发货日期,6,5)>='05-26' AND SUBSTR(发货日期,6,5)<='06-25' THEN '第2季度'

WHEN SUBSTR(发货日期,6,5)>='06-26' AND SUBSTR(发货日期,6,5)<='07-25' THEN '第3季度'

WHEN SUBSTR(发货日期,6,5)>='07-26' AND SUBSTR(发货日期,6,5)<='08-25' THEN '第3季度'

WHEN SUBSTR(发货日期,6,5)>='08-26' AND SUBSTR(发货日期,6,5)<='09-25' THEN '第3季度'

WHEN SUBSTR(发货日期,6,5)>='09-26' AND SUBSTR(发货日期,6,5)<='10-25' THEN '第4季度'

WHEN SUBSTR(发货日期,6,5)>='10-26' AND SUBSTR(发货日期,6,5)<='11-25' THEN '第4季度'

WHEN SUBSTR(发货日期,6,5)>='11-26' AND SUBSTR(发货日期,6,5)<='12-25' THEN '第4季度'

END 月份

,SUM(运货费) 运货费

FROM 订单

WHERE SUBSTR(发货日期,1,10)>=(SUBSTR('${A}',1,4)-1)||'-12-26'

AND SUBSTR(发货日期,1,10)<=SUBSTR('${A}',1,4)||'-12-25'

GROUP BY 月份

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

我这个是用设计器自带的SQLite数据库编写的，你把其中的一些语法更改为你的数据库语法就行