SELECT 
	MEMBER_CODE as MEMBER
	,EMAIL as EMAIL
-- 	,抜き出したドメイン名 as DOMAIN
	,replace(substring(substring
	    (EMAIL
	    , INSTR(EMAIL,'.co.jp')
	    ,-100
	    )
    ,INSTR(
        substring
	    (EMAIL
	    , INSTR(EMAIL,'.co.jp')
	    ,-100
	    ),'@'
        
    ),100
    ),'@','')


    
FROM MEMBER_MST
-- WHERE

ORDER BY 
-- 	DOMAIN desc
	MEMBER desc
;