table
id class chengji
1 1 33
2 1 89
3 2 34
4 2 77
select class avg(chengJi) max(chengji) min(chengJi) from table group by class
select banji,avg(fengshu),max(fengshu),min(fengshu) from chengji group by banji
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024