Select
 EMP_CODE as CODE,
 EMP_ENG_NAME as NAME,
 LENGTH(EMP_ENG_NAME) as WORD_CNT
From
 EMP
Where
 WORD_CNT > 15 and
 NAME is not null
Order by
 WORD_CNT desc,
 CODE asc;