设有学生表S(SNO，SN)(SNO为学生号，SN为姓名)
答案:1 悬赏:60 手机版
解决时间 2021-03-21 11:31
- 提问者网友：蔚蓝的太阳
- 2021-03-20 13:12
设有学生表S(SNO，SN)(SNO为学生号，SN为姓名)
最佳答案
- 五星知识达人网友：大漠
- 2021-03-20 14:31
(1)
create view V_ssc(SNO,SN,CNO,CN,C)
as
select S.SNO,SN,CNO,CN,C
from S,SC
where S.SNO=SC.SNO
order by CNO asc
(2)
select SN,CN,C
from V_SSC
group by SNO
having avg(C)>90
create view V_ssc(SNO,SN,CNO,CN,C)
as
select S.SNO,SN,CNO,CN,C
from S,SC
where S.SNO=SC.SNO
order by CNO asc
(2)
select SN,CN,C
from V_SSC
group by SNO
having avg(C)>90
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯