SELECT
    MEMBER_CODE AS MEMBER
,   EMAIL AS EMAIL
,   SUBSTR(
        EMAIL
,       INSTR(EMAIL, "@") + 1
,       (INSTR(EMAIL, ".co.jp") - 1) - INSTR(EMAIL, "@")
    ) AS DOMAIN
FROM
    MEMBER_MST
ORDER BY
    DOMAIN DESC
,   MEMBER DESC;