select S#,avg(score)from scgroup by S# having avg(score) >60;
上一篇 分组:Group by
下一篇 8、查询所有课程成绩小于60分的同学的学号、姓名;
版权所有 (c)2021-2022 MSHXW.COM
ICP备案号:晋ICP备2021003244-6号