Question

从学生选课数据库中查询选修“数据库原理”课并且成绩在90分以上的学生名单,请写出SQL语句.

Answer 1

select sname from student

where sno in(

select a.sno from studentcourse a join course b

on a.cno=b.cno

where b.cname='数据库原理' and a.score>90)

select a.sclass as 班级,count(*) as 不及格人数 from

student a join studentcourse b

on a.sno=b.sno

where b.score