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