学生选课的关系模式为SC(SN,CN,SM),其中SN为学号,CN为课程号,SM为成绩。检索选修3门以上课程的学生总成绩,并按总成绩的降序排列。
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