sql语句的判断写法

select u_ticket_number as '准考证号',u_name as '姓名',
case 
when u_english >= 90 then '优秀'
when u_english >=60 and u_english < 90 then '及格'
else '不及格'
end as '英语'  
from u_info;