假设有关系marks(ID,score),我们希望基于如下标准为学生评定等级:如果score < 40 得F;如果40<=score<60得C;如果60<=score<80得B;如果80<=score得A。写出SQL查询完成下列操作:
为了学生操作,首先创建关系:
create table marks(
ID varchar not null,
score int,
primary key(ID)
);
再添加一些样本数据:
insert into marks values(1, 10);insert into marks values(2, 20);
insert into marks values(3, 30);insert into marks values(4, 40);
insert into marks values(5, 40);insert into marks values(6, 60);
insert into marks values(7, 70);insert into marks values(8, 80);
insert into marks values(9, 90);insert into marks values(10, 100);
执行后,查看插入结果:
select * from marks;
id | score
----+-------
1 | 10
2 | 20
3 | 30
4 | 40
5 |