select
    CODE
    , NAME
    , sum(cnt) CNT
from (
    select
        CODE
        , NAME
        , od
        , case when count(*) > 0 then 1 else 0 end cnt
    from (
        select
            o.CUST_CODE CODE
            , c.CUST_NAME NAME
            , o.ORDER_DATE od
        from ORDERS o
        left join CUSTOMER c on c.CUST_CODE=o.CUST_CODE
        where o.ORDER_DATE>=datetime('2023-07-01')
            and o.ORDER_DATE<datetime('2023-08-01')
        ) a
    group by CODE, NAME, od
    ) b
group by CODE, NAME
order by CNT desc, CODE desc