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