SELECT 
    MEMBER_CODE AS MEMBER
    , EMAIL
    , SUBSTRING(REPLACE(EMAIL, '.co.jp', ''), INSTR(EMAIL, '@') + 1) AS DOMAIN
FROM
    MEMBER_MST
ORDER BY
    DOMAIN DESC
    , MEMBER DESC;