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