SELECT ${IF(课程=="语文","SUM(语文成绩)",IF(课程=="数学","SUM(数学成绩)","SUM(英语成绩)"))} [总成绩] FROM TABLE WHERE 1=1$(if(len(起始日期)==0," AND 日期>='"+起始日期+"'"))$(if(len(截止日期)==0," AND 日期<='"+截止日期+"'"))$(if(len(姓名)==0," AND 姓名 like '%"+姓名+"%'"))

select sum(成绩) from 表 where 学生='学生' and 年月 between '${起始年月}' and '${截止年月}'

参考这个-https://help.fanruan.com/finereport/doc-view-4192.html

select 年月,学生,sum(课程成绩) from 表 

where 学生='学生' 

and 年月 >= '${起始年月}' 

and 年月 <= '${截止年月}'

group by 年月,学生