检索选修四门以上课程的学生总成绩(不统计不及格的课程) 并要求按总成绩降序排列出来 正确的SELE

检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩降序排列出来，正确的SELECT语句是______。

A．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 CROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)＞=4

B．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY 2 DESC

C．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY 2 DESC

D．DELECT S#,SUM(GRADＥ)FROM SC WHERE GRADE＞=60 ORDER BY 2 DESC CROUP BY S# HAVING COUNT(*)＞=4