select u_id , u_name , u_score ,
(
case when u_score >= 65.45 then '优秀'
when u_score >=60 and u_score<85 then '及格'
else '不及格'
end
) as level
from T_USER ;
select u_id , u_name , u_score ,
(
case when u_score >= 65.45 then '优秀'
when u_score >=60 and u_score<85 then '及格'
else '不及格'
end
) as level
from T_USER ;