select
    member_code as MEMBER
    ,email as EMAIL
    ,substr(
        email,
        instr(email, '@')+1,
        instr(email, '.co.jp') - instr(email, '@') - 1
    ) as DOMAIN
from
    member_mst
order by
    DOMAIN desc
    ,MEMBER desc
;