20、查询score中选学多门课程的同学中分数为非最高分成绩的记录。
SELECT *
FROM (SELECT *
FROM SCORE
WHERE DEGREE not in (SELECT MAX(DEGREE) DEGREE FROM SCORE group by CNO)) t1
WHERE SNO NOT IN (SELECT SNO
FROM SCORE
GROUP BY SNO
HAVING COUNT(SNO)<=1)
ORDER BY SNO ASC