SQL查询：找出与张三至少选修一门相同课程的学生

SELECT DISTINCT S.Sname, C.Cname FROM Student S, Course C, SC WHERE S.Sno = SC.Sno AND C.Cno = SC.Cno AND S.Sname <> '张三' AND SC.Cno IN ( SELECT Cno FROM SC WHERE Sno = ( SELECT Sno FROM Student WHERE Sname = '张三' ) );