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;