SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for student_data-- ----------------------------DROP TABLE IF EXISTS student_data;CREATE TABLE student_data student_id INT11
SELECT gender, COUNT(*) AS count, AVG(score) AS avg_score FROM student_data GROUP BY gender; 截图:见附件
原文地址: https://www.cveoy.top/t/topic/chjt 著作权归作者所有。请勿转载和采集!