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