case when then end

create table studentscore
(  
id int PRIMARY key auto_increment,  
name nvarchar(20) not null,  
subject nvarchar(20) not null,  
score int not null  

);  

insert studentscore(name,subject,score) values ('张三','语文','60');  
insert studentscore(name,subject,score) values ('张三','数学','65');  
insert studentscore(name,subject,score) values ('张三','外语','70');  
insert studentscore(name,subject,score) values ('李四','语文','80');  
insert studentscore(name,subject,score) values ('李四','数学','90');  
insert studentscore(name,subject,score) values ('李四','外语','85');  
insert studentscore(name,subject,score) values ('王五','语文','70');  
insert studentscore(name,subject,score) values ('王五','数学','71');  
insert studentscore(name,subject,score) values ('王五','外语','75');  
insert studentscore(name,subject,score) values ('赵六','语文','64');  
insert studentscore(name,subject,score) values ('赵六','数学','67');  

insert studentscore(name,subject,score) values ('赵六','外语','76'); 

SELECT
NAME,
SUBJECT,
(
CASE 
WHEN score >=80 THEN
'优秀'
WHEN score >= 60 THEN
'及格'
ELSE
'不及格' END
) AS 等级 
FROM
studentscore;