SELECT
    EMP_CODE AS CODE,
    EMP.EMP_LAST_NAME AS SURNAME,
    EMP.EMP_FIRST_NAME AS NAME
FROM (
    SELECT
        *,
        REPLACE(EMP_LAST_NAME, " ", "") AS last_name,
        REPLACE(EMP_FIRST_NAME, " ", "") AS first_name
        
    FROM
        EMP
) AS EMP
INNER JOIN (
    SELECT
        *
    FROM (
        SELECT
            EMP_LAST_NAME,
            EMP_FIRST_NAME,
            COUNT(1) AS cnt
        FROM (
            SELECT
                REPLACE(EMP_LAST_NAME, " ", "") AS EMP_LAST_NAME,
                REPLACE(EMP_FIRST_NAME, " ", "") AS EMP_FIRST_NAME
            FROM
                EMP
            WHERE
                VALID_FLG = 1
        )
        GROUP BY
            EMP_LAST_NAME,
            EMP_FIRST_NAME
    )
    WHERE
        cnt >= 2
) AS logs
ON
    EMP.last_name = logs.EMP_LAST_NAME
    AND EMP.first_name = logs.EMP_FIRST_NAME
ORDER BY
    EMP.last_name ASC,
    EMP.first_name ASC,
    EMP_CODE ASC