select  EMP_CODE CODE
        ,EMP_LAST_NAME || EMP_FIRST_NAME NAME
        ,EMP_ENG_NAME ENG_NAME
        ,case 
         when EMP_ENG_NAME is null then '未入力'
         else substr(replace(EMP_ENG_NAME,' ',''),1,10)
        end CUTOUT_STR
from    EMP
 order by 4 desc ,1 desc