select
    MEMBER_CODE as MEMBER,
    EMAIL,
    replace(substr(EMAIL,instr(EMAIL,"@")+1),".co.jp","") as DOMAIN
from MEMBER_MST
ORDER BY
    DOMAIN desc,
    MEMBER desc
limit 10;