答案窝,daanwo.com

[单选题]"设有三个表,即学生表S,课程表C,学生选课表SC。它们的结构如下: S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE) 检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来()WL8答案窝(daanwo.com)-大学生作业答案及考资分享平台
ASELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING CONT(*)>=4 ;WL8答案窝(daanwo.com)-大学生作业答案及考资分享平台
BSELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY 2 DESC ;WL8答案窝(daanwo.com)-大学生作业答案及考资分享平台
CSELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC ;WL8答案窝(daanwo.com)-大学生作业答案及考资分享平台
DSELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)>=4 ;

答案窝,daanwo.com