select
    MEMBER_CODE AS MEMBER
    ,EMAIL AS EMAIL
    ,replace(substr(EMAIL,instr(EMAIL,'@')+1),'.co.jp','') AS DOMAIN
from
     MEMBER_MST
order by
    DOMAIN desc
    ,MEMBER desc
    ;