列出存在有85分以上成绩的课程CNO。

参考答案:

SELECT DISTINCT CNO FROM SCORE WHERE DEGREE IN(SELECT DEGREE FROM SCORE WHERE DEGREE＞85)；SELECT DISTINCT CNO FROM SCORE WHERE DEGREE IN(SELECT DEGREE FROM SCORE WHERE DEGREE＞85)；