列出成绩比该课程平均成绩低的同学的成绩表。
点击查看答案
参考答案:
SELECT CNOSNODEGREE FROM SCORE A WHERE DEGREE(SELECT AVG(DEGREE)FROM SCORE B WHEREA.CNO=B.CNO);SELECT CNO,SNO,DEGREE FROM SCORE A WHERE DEGREE(SELECT AVG(DEGREE)FROM SCORE B WHEREA.CNO=B.CNO);
计算机四级