with A as (
select
    MEMBER_CODE as MEMBER,
    EMAIL,
    substring(EMAIL, instr(EMAIL,'@')+1) as DOMAIN
from
    MEMBER_MST
)
select
    MEMBER,
    EMAIL,
    substring(DOMAIN, 1, instr(DOMAIN,'.')-1) as DOMAIN
from
    A

order by
    DOMAIN,
    MEMBER