A-A+
【简答题】查询两门及其以上不及格课程的同学的学号 姓名及其平均成绩
问题详情
【简答题】查询两门及其以上不及格课程的同学的学号，姓名及其平均成绩
参考答案
select sc.S no ,AVG( sc. grade ) from SC where sc.S no in ( select sc2.S no from SC sc2 where sc2.Score<60 group by sc2.S no having COUNT(sc2.C no )>2 ) group by sc.S no