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