SELECT MEMBER_CODE AS MEMBER,
       EMAIL AS EMAIL,
       substr(replace(EMAIL,'.co.jp',''),instr(replace(EMAIL,'.co.jp',''),'@') + 1 ,99) AS DOMAIN
            from MEMBER_MST
        order by
            DOMAIN desc,
            MEMBER desc;