--【問題2】
SELECT DISTINCT
	A.EMP_CODE AS CODE
,	A.EMP_LAST_NAME AS SURNAME
,	A.EMP_FIRST_NAME AS NAME
FROM
	EMP A
,	EMP B
WHERE
	REPLACE(A.EMP_FIRST_NAME,' ','') = REPLACE(B.EMP_FIRST_NAME,' ','')
AND	REPLACE(A.EMP_LAST_NAME,' ','') = REPLACE(B.EMP_LAST_NAME,' ','')
AND	A.EMP_CODE <> B.EMP_CODE
AND	A.VALID_FLG = '1'
AND	B.VALID_FLG = '1'
ORDER BY
	REPLACE(A.EMP_LAST_NAME,' ','')
,	REPLACE(A.EMP_FIRST_NAME,' ','')
,	A.EMP_CODE