列出选修编号为“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 DEGREE DESC；