select
    	 emp_code CODE
    	,EMP_LAST_NAME || EMP_FIRST_NAME NAME
    	,EMP_ENG_NAME  ENG_NAME
    	,IFNULL(substr(replace(EMP_ENG_NAME, ' ', ''), 1, 10), '未入力') CUTOUT_STR
    from emp
    order by 4 desc, code desc
    ;