select
    MEMBER_CODE as MEMBER
    ,EMAIL
    ,substr(EMAIL,instr(EMAIL,'@')+1, instr(EMAIL,'.')-instr(EMAIL,'@')-1) as DOMAIN
from MEMBER_MST
order by 3 desc, 1 desc;