我的 case when 例子

SELECT 
    id, 
    name,
    CASE 
        WHEN TYPE = 1 THEN '验光员'
        WHEN status BETWEEN 0 AND 1 THEN '未成年人'
        ELSE '其它'
    END AS '验光组',
    CASE 
        WHEN TYPE = 0 THEN '销售员'
        WHEN status BETWEEN 0 AND 1 THEN '未成年人'
        ELSE '其它'
    END AS '销售组'
FROM glg_base_staff;