SELECT class_id,round(avg(score),2) class_average from students group by class_id; SELECT class_id,gernder,round(avg(score),2) class_average from students group by class_id,gender;
Sign in to make a reply
邢念行知
SELECT class_id,round(avg(score),2) class_average from students group by class_id; SELECT class_id,gernder,round(avg(score),2) class_average from students group by class_id,gender;