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