select
    EMP_CODE as CODE
    , EMP_ENG_NAME as NAME
    , LENGTH(EMP_ENG_NAME) as WORD_CNT 
from
    emp 
where
    EMP_ENG_NAME IS NOT NULL 
    and LENGTH(EMP_ENG_NAME) >= 15 
order by
    LENGTH(EMP_ENG_NAME) desc
    , EMP_CODE asc