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