SELECT
      MEMBER_CODE  AS MEMBER
    , EMAIL AS EMAIL
    , substr(EMAIL,instr(EMAIL,'@') +1,length(EMAIL) - (instr(EMAIL,'@') +6)) AS DOMAIN
FROM
     MEMBER_MST
 WHERE
     EMAIL LIKE '%co.jp'
ORDER BY
     DOMAIN DESC
    ,MEMBER DESC
;