SELECT class_id, gender,round(AVG(score),1) AVG_score from students GROUP by class_id,gender;
Sign in to make a reply
1你萌死啦
SELECT class_id, gender,round(AVG(score),1) AVG_score from students GROUP by class_id,gender;