mysql 数值函数之case 运算符应用

 利用case数值函数进行多表达式判断选择

use sql_store;
select concat(first_name,' ',last_name) as customers,points,
case 
    when points > 3000  then 'gold'
    when points >= 2000 then 'sliver'
    when points < 2000  then 'bronze' -- or else 'bronze'
    end as category
from customers