select 
member_code as MEMBER,
email as EMAIL,
SUBSTR(email, instr(email, '@') + 1, instr(email, '.co.jp') - instr(email, '@') - 1) as DOMAIN
from member_mst
order by DOMAIN desc, MEMBER desc;