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;