--创建表，包含学号和成绩字段
create table students
(
snum char(10),
score float
)
--向表中插入成绩
insert into students(snum,score) values ('011',100)
insert into students(snum,score) values ('012',90)
insert into students(snum,score) values ('013',70)
insert into students(snum,score) values ('014',65)
insert into students(snum,score) values ('015',60)
insert into students(snum,score) values ('016',55)
insert into students(snum,score) values ('017',50)
insert into students(snum,score) values ('018',35)
insert into students(snum,score) values ('019',59)
insert into students(snum,score) values ('020',43)
--把不及格的学生选出来，放入另外一张表
select * into students2 from students where score < 60
--把他们的补考成绩添加进去(可以用更新表)
update students2 set score = 补考成绩 where snum = '016'
--同样把其他同学补考成绩修改
--------------------------------------不知道这样回答行不行
