WITH NAME_LENGTH AS (
    SELECT 
        EMP_CODE AS CODE,
        EMP_ENG_NAME AS NAME,
        LENGTH(EMP_ENG_NAME) AS WORD_CNT
    FROM EMP
    WHERE LENGTH(EMP_ENG_NAME) >= 15
)
SELECT * 
FROM NAME_LENGTH
ORDER BY WORD_CNT DESC, CODE ASC;