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