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