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