题目内容
（请给出正确答案）
提问人：网友qq496683952
发布时间：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 and COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC;
C、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade;
D、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC;
简答题官方参考答案
（由简答题聘请的专业题库老师提供的解答）
查看官方参考答案
