...现在要按季度查出每个季度订购的金额,写出sql语句,怎么写?答:假设日期是字符类型,表达形式如200902 select 金额,sum(case when right(日期,2)>='1' and right(日期,2)<='3' then 金额 else 0 end ) as 第一季度,sum(case when right(日期,2)>='4' and right(日期,2)<='6' then 金额 else 0 end ) as 第二季度,sum(case when right(日期,...