Select StuID as 学号,Avg(Score) as 平均成绩 From tblScore sc
Where (Select Count(*) From tblScore s1 Where s1.StuId=sc.StuId And Score<60)>=2 Group By StuId
查询结果如下
查询两门以上不及格课程的同学的学号及其平均成绩
最新推荐文章于 2024-08-30 18:33:43 发布
Select StuID as 学号,Avg(Score) as 平均成绩 From tblScore sc
Where (Select Count(*) From tblScore s1 Where s1.StuId=sc.StuId And Score<60)>=2 Group By StuId
查询结果如下