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;