SELECT
    MEMBER_CODE AS MEMBER
    , EMAIL AS EMAIL
    , replace(replace(substring(EMAIL , instr(EMAIL , '@')),'.co.jp',''),'@','') AS DOMAIN
FROM
    MEMBER_MST
ORDER BY
    DOMAIN DESC
    , MEMBER DESC
;