SELECT
    MEMBER_CODE as MEMBER
    , EMAIL
    , SUBSTR(EMAIL, INSTR(EMAIL, '@') + 1, (INSTR(EMAIL, '.co.jp') - 1) - INSTR(EMAIL,'@')) as DOMAIN

FROM
    MEMBER_MST
ORDER BY
    DOMAIN DESC
    , MEMBER DESC;