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 '未入力' else substr(replace(emp_eng_name, ' ', ''),1,10) end as cutout_str
    
from 
    emp 

order by 
    cutout_str desc , code desc