建立数据库School其中存放以下三个表：学生Student学号姓名性别年龄系别即Sno char 3 Sname char4 Ssex char 2 Sage int Sdept char6；课程Course课程号课程名任课教师即Cno char3 Cname char8 teacher char4；选修SC学号课程号分数即Sno char 3 Cno char 3 Grade int。 查询至

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 = '张三' ) );