题目内容
（请给出正确答案）
提问人：网友b11b6b82
发布时间：2022-01-07
[主观题]
已知选课关系SC（S# char（8), C# char（8), GRADE integer)，S#学号，C#课程号，GRADE成绩。检索选修4门以上课程的学生总成绩（不统计不及格的课程），并要求按总成绩的降序排列出来。正确的SELECT语句是_________。
A、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade DESC
B、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade
C、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC
D、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 and COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC
简答题官方参考答案
（由简答题聘请的专业题库老师提供的解答）
查看官方参考答案
