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 3 DESC, 1 DESC;