select
   MEMBER_CODE as MEMBER
 , EMAIL as EMAIL
 , rtrim(substring(EMAIL, instr(EMAIL, '@') + 1), '.co.jp') as DOMAIN
from MEMBER_MST
order by
   substring(EMAIL, instr(EMAIL, '@') + 1) desc
 , MEMBER_CODE desc;