填空题
VF
题号 #154349
在成绩表中,检索选修3门以上课程的学生的及格学科的总成绩。成绩表中包含学号、姓名、课程名和成绩4个字段。请将下面的SQL语句补充完整。
SELECT 学号,SUM(成绩) FROM ______;
WHERE 成绩>=60;
GROUP BY学号;
______ COUNT(*) >=3
参考答案
暂无
答案解析
成绩表;HAVING
你可能感兴趣的试题
A.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
HAVING COUNT(*)>=2
HAVING COUNT(*)>=2
B.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
GROUP BY 仓库号 HAVING COUNT(*)>=2
GROUP BY 仓库号 HAVING COUNT(*)>=2
C.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
GROUP BY 仓库号 SET COUNT(*)>=2
GROUP BY 仓库号 SET COUNT(*)>=2
D.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
GROUP BY 仓库号 WHERE COUNT(*)>=2
GROUP BY 仓库号 WHERE COUNT(*)>=2
A.A1
B.A3
C.A1,A2
D.A1,A3