查询每门课程各个班级的平均分数,最高分数,总分数,课程名,班级名
SELECT AVG(Grade) AS 平均分, MAX(Grade) AS 最高分数, SUM(Grade) AS 总分数 , Sname, Class FROM sc GROUP BY Sname,Class