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

将学生的学号及平均成绩及格的学生定义成一个视图pjcj (  )

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

题目:将学生的学号及平均成绩及格的学生定义成一个视图pjcj (  )

create view pjcj as select stuid,avg(grade) from sc group by stuid having avg(grade)>=60
create view pjcj as select stuid,avg(grade) from sc where avg(grade)>=60 group by stuid
create view pjcj(学号,平均成绩) as select stuid,avg(grade) from sc group by stuid having avg(grade)>=60
create view pjcj(学号,平均成绩) as select stuid,avg(grade) from sc where avg(grade)>=60group by stuid

喵查答案:["create view pjcj(学号,平均成绩) as select stuid,avg(grade) from sc group by stuid having avg(grade)>=60"]
喜欢 (0)
关于作者: