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;