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