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