检索选修四门以上课程的学生总成绩，并要求按总成绩的降序排列出来。正确的SELECT语句是（ ）。


A.SELECTSNO, SUM (GRADE) FROM SC GROUP BYSNO ORDER BY2 DESC HAVING COUNT(*)

B.SELECTSNO, SUM (GRADE) FROM SC GROUP BYSNO HAVING COUNT(*)=4 ORDER BY2 DESC;

C.SELECTSNO, SUM (GRADE) FROM SC HAVING COUNT(*)=4 GROUP BYSNO ORDER BY2 DESC;

D.SELECTSNO, SUM (GRADE) FROM SC ORDER BY2 DESC GROUP BYSNO HAVING COUNT(*)


点击这里跳转到答案查看网获取答案