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;