with last_order as (
    select
        *
    from
        ec_orders as eo,
        member_mst as mm
    where
        order_datetime < "2023-07-01"
    group by
        eo.member_code
    order by
        order_datetime desc
)

select
    eo.order_datetime as ORDER_DATE,
    mm.member_code as CODE,
    case
        when mm.optout_type = 0 then "可"
        when mm.optout_type = 1 then "不可"
        else "不明"
        end as OPTOUT
from
    ec_orders as eo,
    member_mst as mm,
    last_order as lo
where
    (order_date between "2023-07-01" and "2023-08-01")
    and eo.member_code = lo.member_code
group by
    code
order by
    order_date desc,
    code desc