【名词&注释】
局域网(lan)、只读存储器(read only memory)、校验码(check code)、奇偶校验(parity check)、总成绩(total score)
[单选题]学生选课的关系模式为SC(SN,CN,SM),其中SN为学号,CN为课程号,SM为成绩。检索选修3门以上课程的学生总成绩(total score),并按总成绩(total score)的降序排列。 SELECT SN,SUM(SM) FROM SC ______0RDER BY 2 DESC;
A. GROUP BY SN HAVING COUNT(*)>=3
B. HAVINGCOUNT(*)>=3 GROUP BY SN
C. GROUP BY SM HAVING COUNT(*)>=3
D. HAVING COUNT(*)>=3 GROUP BY SM