select
    od.cust_code as CODE
    ,c.cust_name as NAME
    ,count(od.order_date) as CNT
from
    (
        select
            distinct order_date, cust_code
        from
            orders
        where
            order_date >= '2023-07-01'
            and order_date <= '2023-07-31'
    ) as od
join
    customer c
on
    od.cust_code = c.cust_code
group by
    1, 2
order by
    3 desc, 1 desc;