select
    O.CUST_CODE as CODE
    , C.CUST_NAME as NAME
    , count(O.CUST_CODE) as CNT
from
    (select
        distinct CUST_CODE, ORDER_DATE
    from
        ORDERS
    where
        ORDER_DATE between '2023-07-01' and '2023-07-31'
    ) as O
inner join
    CUSTOMER as C on O.CUST_CODE=C.CUST_CODE
group by
    CODE
order by
    CNT desc
    , CODE desc
;