select 
    EMP_CODE as CODE
    ,EMP_LAST_NAME||EMP_FIRST_NAME as NAME
    ,EMP_ENG_NAME as ENG_NAME
    ,coalesce(substring(replace(EMP_ENG_NAME,' ', ''), 1, 10), '未入力')  as CUTOUT_STR
from emp
order by 4 desc, 1 desc;