SELECT 
    MEMBER_CODE AS MEMBER
    ,EMAIL
    ,SUBSTR(EMAIL,INSTR(EMAIL,"@")+1,INSTR(EMAIL,".")-1-INSTR(EMAIL,"@")) AS DOMAIN
FROM  MEMBER_MST
ORDER BY DOMAIN,MEMBER DESC;