SELECT AVG(语文) as 语文,AVG(数学) as 数学,AVG(综合) as 综合,AVG(英语) as 英语,AVG(总分) as 总分,班级 FROM cj WHERE 总分<>0 GROUP BY 班级

SELECT AVG(语文) as 语文,AVG(数学) as 数学,AVG(综合) as 综合,AVG(英语) as 英语,AVG(总分) as 总分,班级 FROM cj WHERE 总分<>0 GROUP BY 班级 INTO TABLE pj

不能完全排除 语文 数学 综合 英语 其中有0

SELECT AVG(语文) as 语文,AVG(数学) as 数学,AVG(综合) as 综合,AVG(英语) as 英语,AVG(总分) as 总分,班级 FROM cj WHERE NOT INLIST(0,语文,数学,综合,英语,总分) GROUP BY 班级 INTO TABLE pj

现在应该完全满足要求了吧？

完全符合要求，谢谢！！！