第一题:select class_id,round(avg(score),2) from students group by class_id;
第二题:select class_id, gender, round(avg(score),2) from students group by class_id,gender;
Sign in to make a reply
大笑肖肖
第一题:select class_id,round(avg(score),2) from students group by class_id;
第二题:select class_id, gender, round(avg(score),2) from students group by class_id,gender;