SELECT 
MEMBER_CODE AS MEMBER
,EMAIL AS EMAIL
,REPLACE(EMAIL,'.co.jp','') AS DOMAIN
--,抜き出したドメイン名 AS DOMAIN
FROM MEMBER_MST
ORDER BY DOMAIN DESC
,MEMBER DESC
;