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