SELECT
 MEMBER_CODE AS MEMBER
,EMAIL AS EMAIL
,TRIM(substr(EMAIL, INSTR(EMAIL,('@')) + 1 ), '.co.jp') AS DOMAIN
FROM MEMBER_MST
WHERE EMAIL NOT NULL
ORDER BY DOMAIN DESC ,MEMBER DESC;