按照课程号进行分组,统计学生平均成绩大于60分的学生的信息()
A.select cid,avg(grade) from student where avg(grade)>60 group by cid
B.select cid,avg(grade) from student group by cid having avg(grade)>60
C.select cid,avg(grade) from course where avg(grade)>60 group by cid
D.select cid,avg(grade) from sc group by cid having avg(grade)>60
参考答案:
select cid,avg(grade) from sc group by cid having avg(grade)>60
类别: 题库 | 2023-06-11
类别: 题库 | 2023-06-11
类别: 题库 | 2023-06-11
类别: 题库 | 2023-06-11
类别: 题库 | 2023-06-11
类别: 题库 | 2023-06-11
类别: 题库 | 2023-06-11
类别: 题库 | 专业技术人员继续教育 2023-06-11
类别: 题库 | 专业技术人员继续教育 2023-06-11
类别: 题库 | 专业技术人员继续教育 2023-06-11