select
    emp_code as CODE
    , emp_last_name || emp_first_name as NAME
    , emp_eng_name as ENG_NAME
    , CASE WHEN emp_eng_name IS NULL
                THEN '未入力'
            WHEN emp_eng_name IS NOT NULL
                THEN SUBSTR(REPLACE(emp_eng_name, " ", ""), 1, 10) 
        END as CUTOUT_STR
from emp
ORDER BY cutout_str desc,
        code desc;