【求助】查询学过学号为“1”同学所有课程的其他同学学号和姓名（好难的）

Question

查询学过学号为“1”同学所有课程的其他同学学号和姓名

Answer 1

SELECT stu.Sid, stu.Sname FROM Student stu INNER JOIN SC score2ON (stu.Sid = score2.Sid) WHERE score2.Cid IN (SELECT Cid FROM SC score WHERE score.Sid = '1' )GROUP BY stu.Sid, stu.SnameHAVING COUNT(score2.Cid) = (SELECT COUNT(1) FROM SC score WHERE score.Sid = '1' ) AND stu.Sid <> '1'