【数据库原理】闯关作业答案
实验二
四个关卡
作者：HYQ2419341043
第一关：
insert into Student (sno, sname, ssex, sage, sdept) values ('001','Smith','m',18,'CS');
insert into Student (sno, sname, ssex, sage, sdept) values ('002','Ketty','f',19,'MA');
insert into Course (cno,cname,cpno,ccredit) values ('C01','DB',null,2);
insert into Course (cno,cname,cpno,ccredit) values ('C02','Oracle','C01',3);
insert into SC (sno,cno,grade) values ('001','C01',70);
insert into SC (sno,cno,grade) values ('001','C02',82);
insert into SC (sno,cno,grade) values ('002','C01',86);
第二关
update SC set grade=grade+5 where grade<60;
update Student set Sage=Sage+1 where Ssex='m' and Sdept='CS';
update Student set Sno='S'+Sno where Sno!='';
第三关
update Student set Sno = REPLACE(Sno, 'S', '');
update Student set Sno=RTRIM(Sno)+'S';
第四关
delete from SC where grade is null;
delete from Student where Ssex='f'and Sage = '18'
delete from course where ccredit=3;
作者：HYQ2419341043
相关文章
Odessa
2020-03-06
Rachel
2023-07-20
Psyche
2023-07-20
Winola
2023-07-20
Gella
2023-07-20
Grizelda
2023-07-20
Janna
2023-07-20
Ophelia
2023-07-21
Crystal
2023-07-21
Laila
2023-07-21
Aine
2023-07-21
Bliss
2023-07-21
Lillian
2023-07-21
Tertia
2023-07-21
Olive
2023-07-21
Angie
2023-07-21
Nora
2023-07-24
