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