select 
  member_code as MEMBER 
  ,email as EMAIL 
  ,replace(substr(email, instr(email, '@') + length('@')), '.co.jp', '') as DOMAIN
from MEMBER_MST
order by DOMAIN desc, MEMBER desc 
;