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;