SELECT
    MEMBER_CODE as 'MEMBER'
    ,EMAIL as 'EMAIL'
    ,substring_index(TRIM(EMAIL,'.co.jp'),'@',-1) as 'DOMAIN'
FROM
    MEMBER_MST
ORDER BY
    DOMAIN desc
    ,MEMBER desc
;