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