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