SELECT class_id,ROUND(AVG(score),2) avg_score FROM students GROUP BY class_id;
class_id
score
SELECT class_id,gender,ROUND(AVG(score),2) avg_score FROM students GROUP BY class_id,gender;
gender
Sign in to make a reply
野比豆豉
SELECT
class_id,ROUND(AVG(score),2) avg_score FROM students GROUP BYclass_id;SELECT
class_id,gender,ROUND(AVG(score),2) avg_score FROM students GROUP BYclass_id,gender;