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