select *,
case when ((score>=0 and score <60) then '不及格'
when (score>=60 and score<80) then '一般'
when (score>=80 and score<90) then '良好'
when (score>=90 and score<100) then '优秀'
else '分数有问题吧'
end as '是否及格'
from student;
case when ((score>=0 and score <60) then '不及格'
when (score>=60 and score<80) then '一般'
when (score>=80 and score<90) then '良好'
when (score>=90 and score<100) then '优秀'
else '分数有问题吧'
end as '是否及格'
from student;