1. select class_id,AVG(score)as fenshu from students group by class_id;
2. select class_id,gender,AVG(score)as fenshu from students group by class_id,gender;
Sign in to make a reply
橘子汽水味的程序媛
1. select class_id,AVG(score)as fenshu from students group by class_id;
2. select class_id,gender,AVG(score)as fenshu from students group by class_id,gender;