实验5 创建视图(8)

38、查询选修了课程1又选修了课程2的学生

select Sno from SC where Cno='1' intersect Select Sno from SC where Cno='2'

39、查询选修了1号课程的计算机系学生

select Sdept_Student.Sno,Sname from Sdept_Student,SC

where Sdept_Student.Sno=SC.Sno and SC.Cno='1'