select 

EMP_CODE AS CODE,
EMP_ENG_NAME AS ENG_NAME

FROM
 EMP

WHERE
 ENG_NAME LIKE  '%s%' AND  ENG_NAME LIKE '%S%' 



ORDER BY
 EMP_CODE ASC;