10. delete student where sdept = 'IS'
9. UPDATE SC SET GRADE = GRADE + (GRADE * 0.1) WHERE CNO = 1
8. UPDATE Student set sage = sage +1
7. insert into sc (sno,cno, grade) values ('200215123',4,88)
insert into sc (sno,cno, grade) values（'200215124',1,80)
insert into sc (sno,cno, grade) values（'200215125',5,78）
6. insert into student (sno, sname,ssex,sage,sdept) values （'200215125'，'陈冬'，'男'，20,'IS'）
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024