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