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