with a as (select MEMBER_CODE, min(DATE(ORDER_DATETIME)) as mind, min(ORDER_DATETIME) as mindt
           from EC_ORDERS
           where DATE(ORDER_DATETIME) between '2023-07-01' and '2023-08-00'
           group by MEMBER_CODE)

select max(a.mindt)               ORDER_DATE
     , me.MEMBER_CODE         as CODE
     , max(case ifnull(OPTOUT_TYPE,3)
               when 0 then '可'
               when 1 then '不可'
               else '不明' end) as OPTOUT


from EC_ORDERS ec
     inner join MEMBER_MST me on ec.MEMBER_CODE = me.MEMBER_CODE
     join a on a.MEMBER_CODE = ec.MEMBER_CODE
where DATE(ec.ORDER_DATETIME) < DATE(a.mind, '-1 years')
group by ec.MEMBER_CODE
order by 1 desc, 2 desc