报表已经上传,麻烦大家给看一下,谢谢SQL语句如下:select strftime('%Y-%m',订购日期) as 日期,strftime('%Y',订购日期) as 年份,count(订单.订单ID) as 订单数量, sum(case when 是否已付='true' then 1 else 0 end) as 已付订单数量,sum(单价*数量) as 月销量from 订单,订单明细where 订单.订单ID=订单明细.订单ID and 年份='${请选择年份}'group by 日期WorkBook33.cpt