select
  m.MEMBER_CODE as "MEMBER"
 ,m.EMAIL as "EMAIL"
 ,substr(replace(m.EMAIL, '.co.jp', ''), instr(m.EMAIL, '@') + 1, length(m.EMAIL) - length(replace(m.EMAIL, '.co.jp', ''))) as "DOMAIN"
from
 MEMBER_MST m
order by
 "DOMAIN" desc, "MEMBER" desc
;