如何把下面查询“本周年级平均分”和“上周年级平均分”,合到一起?select 年级,'本周年级平均分' = AVG(实际得分)from dbo.班级日考核where convert(varchar(10),日期,23) between '${dateinweek(today(),1)}' and '${today()}'GROUP BY 年级select 年级,'上周年级平均分' = AVG(实际得分)from dbo.班级日考核where convert(varchar(10),日期,23) between '${dateinweek(today()-7,1)}' and '${dateinweek(today()-7,-1)}'GROUP BY 年级