作业一，计算每个班的平均成绩并排序

SELECT class_id,ceiling(AVG(score)) avg_score from students GROUP BY class_id ORDER BY avg_score desc;

作业二，

select class_id,gender,AVG(score) from students GROUP BY gender,class_id;