select
    MEMBER_CODE as MEMBER
    , EMAIL
    , rtrim(substr(EMAIL, instr(email, '@') + 1) , '.co.jp') as DOMAIN
from
    MEMBER_MST
order by
    DOMAIN DESC
    , MEMBER DESC
;