select
 member_code MEMBER
,email EMAIL
,SUBSTR(email, instr(email, '@') + 1, instr(email, '.') - instr(email, '@') - 1) DOMAIN
FROM member_mst
order by 3 desc, 1 desc
;