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