select * from Student where Student.SNo in( select SC.sno from StudentCourse SC where SC.cno=(select cno from Course where CName='数据库原理') and Score>90)
select SClass 班级,count(sno) 不及格人数 from Student where exists(select * from StudentCourse SC where SC.Score<60 group by SC.SNo) group by SClass