select
    emp_code as "CODE"
    ,emp_eng_name as "ENG_NAME"
from
    emp
where
    (length(emp_eng_name) - length(replace(replace(emp_eng_name, 's', ''), 'S', '')))
        / length('s') >= 2
order by
    emp_code
;