查询选修过课程的学生姓名
SELECT
student.studentNo,
student.studentName
FROM
student
WHERE
student.studentNo IN (SELECT score.studentNo FROM score)
查询选修过课程名中包含“系统”的课程的同学学号、姓名和班级编号
SELECT
student.studentNo,
student.studentName,
classNo
FROM
student
WHERE
student.studentNo IN (SELECT studentNo FROM score WHERE courseNo IN (SELECT courseNo FROM course WHERE courseName LIKE '%系统%'))