select  substr(ec7.ORDER_DATETIME,1,10) ORDER_DATE
        ,ec7.MEMBER_CODE CODE
        ,CASE MEM.OPTOUT_TYPE
            WHEN '0' Then '可'
            WHEN '1' Then '不可'
        Else  '不明'
        End OPTOUT
  from  EC_ORDERS ec7,MEMBER_MST MEM
 where  ec7.MEMBER_CODE = MEM.MEMBER_CODE
   and  substr(ec7.ORDER_DATETIME,1,10) >= '2023-07-01'
   and  substr(ec7.ORDER_DATETIME,1,10) <  '2023-08-01'

and  not exists (
   select   'old'
     from   EC_ORDERS old
     where  ec7.MEMBER_CODE = old.MEMBER_CODE
       and  substr(old.ORDER_DATETIME,1,10) > datetime(substr(ec7.ORDER_DATETIME,1,10), '-1 years')
       and  substr(old.ORDER_DATETIME,1,10) < '2023-07-01'
   )

 order by substr(ec7.ORDER_DATETIME,1,10) desc,ec7.MEMBER_CODE desc