(1)查询信息系(IS)的所有学生的姓名,所选课程号及成绩。
select Sname,Cno,Grade
from Student,SC
where Sdept IN
(select Sdept
from Student
where Sdept='IS')
and Student.sno=SC.sno
(2)查询选修“信息系统”且成绩高于90分的学生学号。
select *
from SC
where Grade>=90 and Cno=
(select Cno
from Course
where Cname='信息系统')
(3)查询选修学分为3或4且参加考试的学生学号、课程号。
select Sno,Cno
from SC
where Cno in
(select Cno
from Course
where Ccredit in(3,4))