select
    EMP_CODE as CODE,
    EMP_LAST_NAME as SURNAME,
    EMP_FIRST_NAME as NAME
from
    emp
where
replace(surname, " ", "") = replace(surname, " ", "")
and replace(name, " ", "") = replace(name, " ", "")
and valid_flg = 1
and emp_code != "10005"
order by
    replace(surname, " ", "") asc,
    emp_code asc