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;