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