with name_list as (
    select EMP_CODE CODE,
            EMP_LAST_NAME SURNAME,
            EMP_FIRST_NAME NAME,
            replace(EMP_LAST_NAME," ","") SURNAME_2,
            replace(EMP_FIRST_NAME," ","") NAME_2
    from emp
    where VALID_FLG = '1'
    ),
    
    count_names as (
    select SURNAME_2,
            NAME_2,
            COUNT(*) cnt
    from name_list
    group by SURNAME_2,NAME_2
    ),
    dup_names as(
    select *
        from count_names
        where cnt >= 2
    )
    
select n.CODE CODE,
        n.SURNAME SURNAME,
        n.NAME NAME
from name_list n
    inner join dup_names d
    on n.SURNAME_2 = d.SURNAME_2
    and n.NAME_2 = d.NAME_2
order by n.SURNAME_2 asc,
    n.CODE asc
;