Discuss / SQL / 作业2：显示出班级name，限制分数位数
Back

作业2：显示出班级name，限制分数位数

Topic source

ContinDo

#1 Created at ... [Delete] [Delete and Lock User]

SELECT classes.`name`, gender, ROUND(AVG(score),2) FROM students,classes 

WHERE students.class_id = classes.id

GROUP BY class_id, gender

ContinDo

#2 Created at ... [Delete] [Delete and Lock User]

SELECT classes.`name`, gender, ROUND(AVG(score),2) as score FROM students,classes 

WHERE students.class_id = classes.id

GROUP BY class_id, gender

  • 1

Reply