SELECT
    EMP_CODE AS CODE
    , EMP_ENG_NAME AS NAME
    , CASE WHEN EMP_ENG_NAME IS NOT NULL THEN LENGTH(EMP_ENG_NAME) END AS WORD_CNT
FROM
    EMP
ORDER BY
    WORD_CNT DESC
    , CODE ASC
;