对于教学数据库的3个基表(S表示学生表,C表示课程表,SC表示学生选课表,假设基表中
答案:1 悬赏:10 手机版
解决时间 2021-03-29 18:07
- 提问者网友：美人性情
- 2021-03-29 07:41
对于教学数据库的3个基表(S表示学生表,C表示课程表,SC表示学生选课表,假设基表中
最佳答案
- 五星知识达人网友：山有枢
- 2021-03-29 08:34
1.create table S
(SNO char(10) primary key,
SNAME varchar(20),
AGE int,
SEX char(2)default '男')
2.SELECt CNO,CNAME FROM C WHERe TEACHER='LI'
3.insert into C values('C01','高等数学','LI')
4.SELECt SNO,SNAME FROM S WHERe AGE>21 AND SEX='男'
5.select CNAME,TEACHER FROM C INNER JOIN SC ON C.CNO=SC.CNO WHERe SC.SNO='S1'
6.SELECt SNAME FROM S
WHERe SEX='男' and SNO in(select SNO from SC inner join
C on SC.CNO=C.CNO WHERe C.TEACHER='LI')
7.select CNO,CNAME FROM C
WHERe CNO in(select CNO from SC inner join
S on SC.SNO=S.SNO WHERe S.SNAME='WANG')
8.SELECt CNO 课程号,SEX 性别,count(*) 总人数,AVG(GRADE) 平均成绩 FROM SC INNER JOIN
S ON SC.SNO=S.SNO group by CNO,SEX
9.select SNAME,SNO from S
where SNO in (select SNO FROM SC group by SNO having count(SNO)>=2)
(SNO char(10) primary key,
SNAME varchar(20),
AGE int,
SEX char(2)default '男')
2.SELECt CNO,CNAME FROM C WHERe TEACHER='LI'
3.insert into C values('C01','高等数学','LI')
4.SELECt SNO,SNAME FROM S WHERe AGE>21 AND SEX='男'
5.select CNAME,TEACHER FROM C INNER JOIN SC ON C.CNO=SC.CNO WHERe SC.SNO='S1'
6.SELECt SNAME FROM S
WHERe SEX='男' and SNO in(select SNO from SC inner join
C on SC.CNO=C.CNO WHERe C.TEACHER='LI')
7.select CNO,CNAME FROM C
WHERe CNO in(select CNO from SC inner join
S on SC.SNO=S.SNO WHERe S.SNAME='WANG')
8.SELECt CNO 课程号,SEX 性别,count(*) 总人数,AVG(GRADE) 平均成绩 FROM SC INNER JOIN
S ON SC.SNO=S.SNO group by CNO,SEX
9.select SNAME,SNO from S
where SNO in (select SNO FROM SC group by SNO having count(SNO)>=2)
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯