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