select MEMBER_CODE as MEMBER, EMAIL as EMAIL, RTRIM(SUBSTR(EMAIL, INSTR(EMAIL, '@') + 1), '.co.jp') as DOMAIN from MEMBER_MST order by DOMAIN desc, MEMBER desc;