sql嵌套查询

书上练习题

select student.studentName,student.studentNo ,Course.courseName ,score.score 

from student,Course ,Score where student.studentNo in (
select a.studentNo from Score a,Course b 
where a.courseNo=b.courseNo and b.courseName='高等数学' and 
a.studentNo in(  select a.studentNo from Score a,Course b where a.courseNo=b.courseNo and b.courseName='计算机原理'))
and student.studentNo=score.studentNo and score.courseNo= Course.courseNo and Course.courseName in('高等数学','计算机原理');