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;