快乐学习 一个网站喵查铺子(catpuzi.com)全搞定~

按照课程号进行分组,统计学生平均成绩大于60分的学生的信息(  )

热门题目 网课答案 2023-06-13 扫描二维码

题目:按照课程号进行分组,统计学生平均成绩大于60分的学生的信息(  )

select cid,avg(grade) from student where avg(grade)>60 group by cid
select cid,avg(grade) from student group by cid having avg(grade)>60
select cid,avg(grade) from course where avg(grade)>60 group by cid
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"]
喜欢 (0)
关于作者: