with SAME_NAME as (
    select
        replace(EMP_LAST_NAME || '-' || EMP_FIRST_NAME, ' ', '') AS NAME
        , count(1)
    from
        EMP
    where
        VALID_FLG = '1'
    group by
        NAME
    having
        count(1) >= 2
)
select
      EMP_CODE AS CODE
    , EMP_LAST_NAME AS SURNAME
    , EMP_FIRST_NAME AS NAME
from
    EMP
inner join 
    SAME_NAME
    on replace(EMP_LAST_NAME, ' ', '') = substr(NAME, 1, instr(NAME, '-') - 1)
    and replace(EMP_FIRST_NAME, ' ', '') = substr(NAME, instr(NAME, '-') + 1)
order by
      NAME
    , EMP_CODE
;