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

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

A．SELECT S#, SUM(GRADE) FROM SC WHERE GRADE＞=60 GROUP 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．SELECT S#, SUM(GRADE)FROM SC WHERE GRADE＞=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)＞=4

提问人：网友longzifeng 发布时间：2022-01-07

参考答案

查看官方参考答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装简答题APP，拍照搜题省时又省心！

更多“检索选修四门以上课程的学生总成绩（不统计不及格的课程)，并要…”相关的问题

第1题

查询出只选修两门课程的学生学号和姓名 SELECT DISTINCT student.SId, student.Sname FROM student, ( SELECT sc.SId, COUNT(*) as a FROM sc GROUP BY(sc.SId)) as A WHERE student.SId = A.SId AND A.a = 2 SELECT Distinct student.Sid, student.Sname FROM student where student.SId in ( SELECT sc.SId FROM sc GROUP BY sc.SId having count(*)=2) 查询男生、女生人数 SELECT Ssex, count(*) FROM student GROUP BY student.Ssex 查询名字中含有「风」字的学生信息 SELECT * FROM student WHERE student.sname LIKE '%风%'; 查询同名同姓学生名单，并统计同名人数 SELECT Sname, count(*) FROM student GROUP BY Sname HAVING COUNT(*) >1; 查询 1990 年出生的学生名单 SELECT * FROM student WHERE sage LIKE '1990-%'; 查询每门课程的平均成绩，结果按平均成绩降序排列，平均成绩相同时，按课程编号升序排列 SELECT sc.CId, avg(sc.score) as avgscore FROM sc GROUP BY sc.CId ORDER BY avg(sc.score) DESC, sc.CId 查询平均成绩大于等于 85 的所有学生的学号、姓名和平均成绩 SELECT student.Sid, student.Sname, t.avgscore FROM student, ( SELECT sc.SId, avg(sc.score) as avgscore FROM sc GROUP BY sc.SId) as t WHERE student.SId = t.SId AND t.avgscore >= 85 查询课程名称为「数学」，且分数低于 60 的学生姓名和分数 SELECT student.Sname, t.score FROM student, ( SELECT sc.SId, sc.score FROM sc WHERE sc.score < 60 AND sc.CId = (SELECT CId FROM course WHERE course.Cname='数学')) as t WHERE student.SId = t.SId 查询所有学生的课程及分数情况（存在学生没成绩，没选课的情况） SELECT st.*, sc.CId, sc.score FROM student AS st LEFT JOIN sc ON st.SId = sc.SId ORDER BY st.SId, sc.CId; 查询任何一门课程成绩在 70 分以上的姓名、课程名称和分数 SELECT student.Sname, course.Cname, sc.score FROM student, course, sc WHERE student.SId = sc.SId AND course.CId = sc.CId AND sc.score > 70 ORDER BY sc.CId 查询不及格的课程 SELECT sc.CId, sc.score FROM sc WHERE sc.score <60 order by>

点击查看答案

第2题

检索选修四门以上课程的学生总成绩，并要求按总成绩的降序排列出来。正确的SELECT语句是（）。

A、SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC GROUP BY SNO ORDER BY SUM_GRADE DESC HAVING COUNT(*) >= 4;

B、SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC GROUP BY SNO HAVING COUNT(*)>=4 ORDER BY SUM_GRADE DESC;

C、SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC HAVING COUNT(*)>=4 GROUP BY SNO ORDER BY SUM_GRADE DESC;

D、SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC ORDER BY SUM_GRADE DESC GROUP BY SNO HAVING COUNT(*)>=4;

点击查看答案

第3题

某高校开设A类选修课四门,B类选修课三门,小刘从中选取四门课程,若要求两类课程各至少选一门,则选法有:()

A.18种

B.22种

C.26种

D.34种

点击查看答案

第4题

假定学生关系是S(S#，SN，SEX，AGE)，课程关系是C(C#，CN)，学生选课关系是SC(S#，C#，GRADE)。其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，C#为课程号，CN为课程名，GRADE为成绩。下列(1)~(3)题均基于该关系模式。（1）检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是( )。

A、SELECT SN，AGE，SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN='王华');

B、SELECT SN，AGE，SEX FROM S WHERE SN＝“王华';

C、SELECT SN，AGE，SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN='王华');

D、SELECT SN，AGE，SEX FROM S WHERE AGE＞王华.AGE;

点击查看答案

第5题

SQL语言中，以下（）关键词不能实现除运算。

A、EXCEPT

B、NOT IN

C、NOT EXISTS

D、INTERSECT

点击查看答案