题目内容（请给出正确答案）

[主观题]

在“成绩”表中，检索选修4门以上课程的男生的姓名和平均成绩。“成绩”表中包含学号、姓名、课

程名称和成绩4个字段。请将下面的SQL语句补充完整。

SELECT姓名，AVG(成绩)AS平均成绩FROM成绩；

WHERE性别=”男”：

GROUPBY学号：

__________COUNT(﹡)＞=4。

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

您可能会需要：

更多“在“成绩”表中，检索选修4门以上课程的男生的姓名和平均成绩。…”相关的问题

第1题

9、已知选课关系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 B

第2题

已知选课关系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 and COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC

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 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade

D.SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)&g

警告：系统检测到您的账号存在安全风险

为了保护您的账号安全，请在“赏学吧”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！

微信搜一搜

赏学吧

点击打开微信

警告：系统检测到您的账号存在安全风险

抱歉，您的账号因涉嫌违反赏学吧购买须知被冻结。您可在“赏学吧”微信公众号中的“官网服务”-“账号解封申请”申请解封，或联系客服。

微信搜一搜

赏学吧

点击打开微信