【参考答案】

A)SELECT CNO,SNO,DEGREE FROM SCORE WHERE CNO IN (SELECT X.CN......

(↓↓↓ 点击下方‘点击查看答案’看完整答案、解析 ↓↓↓)