MySQL查询101课程比102课程成绩高的所有学生的学号

首先，建一个表sc

CREATE TABLE sc(
sno INT,
cno INT,
score INT, 
FOREIGN KEY(sno)REFERENCES student(sno),
FOREIGN KEY(cno)REFERENCES course(cno)
);

再给表sc添加数据

INSERT INTO sc(sno,cno,score) VALUES(1,101,87);
INSERT INTO sc(sno,cno,score) VALUES(2,101,66);
INSERT INTO sc(sno,cno,score) VALUES(3,101,55);
INSERT INTO sc(sno,cno,score) VALUES(4,102,90);
INSERT INTO sc(sno,cno,score) VALUES(5,102,39);
INSERT INTO sc(sno,cno,score) VALUES(6,102,19);
INSERT INTO sc(sno,cno,score) VALUES(7,103,77);
INSERT INTO sc(sno,cno,score) VALUES(8,103,78);
INSERT INTO sc(sno,cno,score) VALUES(9,103,93);
INSERT INTO sc(sno,cno,score) VALUES(10,104,33);
INSERT INTO sc(sno,cno,score) VALUES(11,104,46);
INSERT INTO sc(sno,cno,score) VALUES(12,104,87);
INSERT INTO sc(sno,cno,score) VALUES(1,105,68);
INSERT INTO sc(sno,cno,score) VALUES(2,105,54);
INSERT INTO sc(sno,cno,score) VALUES(3,105,90);
INSERT INTO sc(sno,cno,sco