列出选修编号为“3－105”课程且成绩同于选修了编号为“3－245”的同学的CNO、SNO和DE－GREE。并按DEGREE

参考答案:

SELECT CNOSNODEGREE FROM SCORE WHERE CNO="3-105"AND DEGREE=ANY(SELECT DEGREE FROMSCORE WHERE CNO="3-245")ORDER BY DEGREE DESC；SELECT CNO，SNO，DEGREE FROM SCORE WHERE CNO="3-105"AND DEGREE=ANY(SELECT DEGREE FROMSCORE WHERE CNO="3-245")ORDER BY DEGRE