with
    e1 as
    (
        select
            EMP_CODE,
            replace(EMP_LAST_NAME, ' ', '') as l_name,
            replace(EMP_FIRST_NAME, ' ', '') as f_name
        from EMP
    ),
    e2 as
    (
        select
            l_name as l_name2,
            f_name as f_name2
        from e1
        group by
            l_name,
            f_name
        having
            count(l_name) > 1
            and count(f_name) > 1
        
    ),
    e3 as
    (
        select
            EMP_CODE as e_code3
        from
            e1
        where (l_name, f_name) in e2
    )
select
    EMP_CODE as CODE,
    EMP_LAST_NAME as SURNAME,
    EMP_FIRST_NAME as NAME
from
    EMP
where
    EMP_CODE in
    (
        select e_code3
        from e3
    )
;