题目内容
（请给出正确答案）
提问人：网友audivolvo
发布时间：2022-01-07
[主观题]
已知选课关系SC（S# char（8), C# char（8), GRADE integ...
已知选课关系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 B.SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC C.SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 and COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC D.SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade DESC
简答题官方参考答案
（由简答题聘请的专业题库老师提供的解答）
抱歉！暂无答案，正在努力更新中……
将“选课”表中的1002号课的所有成绩提高10分，正确的SQL语句是________ A. UPDATE 选课 SET 成绩=成绩+10 WHERE 课号=‘1002’； B.UPDATE 选课 SET 成绩=成绩+10 WHERE 课号=1002； C.SET 选课 UPDATE 成绩=成绩+10 WHERE 课号=‘1002’； D.UPDATE 选课 SET 成绩+10 WHERE 课号=‘1002’；
