SQL server查询和01号的同学学习的课程完全相同的其他同学的信息

代码段：

代码段：

SELECT student.SId AS 学号,student.Sname AS 姓名,student.Sage AS 年龄,student.Ssex AS 性别
FROM student
WHERE student.SId<>01 AND student.SId IN 
(SELECT score.SId
FROM score
WHERE score.CId IN
(SELECT score.CId
FROM score
WHERE score.SId=01
) AND NOT IN
(SELECT score.CId
FROM score
WHERE score.SId NOT IN (SELECT score.CId
FROM score
WHERE score.SId=01)
)
GROUP BY score.SId
HAVING COUNT(score.SId)=3
)

表

course

score

student

teacher