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 MEMBER DESC, DOMAIN DESC;