select a.studentNo,studentName,b.courseName,c.score
from Student a,Course b,Score c
where a.studentNo=c.studentNo and b.courseNo=c.courseNo
and a.studentNo in(select studentNo from Score
where courseNo in(select courseNo from Course
where courseName='计算机原理'))
and a.studentNo in(select studentNo from Score
where courseNo in(select courseNo from Course
where courseName='高等数学'))
order by studentNo,score desc