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, ' ', ''), 0, 11)
end
as CUTOUT_STR
from emp as e
order by CUTOUT_STR desc, CODE desc;