SELECT
    EMP_CODE AS CODE
    ,EMP_ENG_NAME AS NAME
    ,LENGTH(EMP_ENG_NAME) AS WORD_CNT
FROM
    EMP
ORDER BY
    LENGTH(EMP_ENG_NAME) DESC
    ,EMP_CODE ASC;