with unique_orders as (
    select distinct
        cust_code,
        order_date
    from
        orders
    where
        order_date >= '2023-07-01' and
        order_date <= '2023-07-31'
)
select
    customer.cust_code as CODE,
    customer.cust_name as NAME,
    count(*) as CNT
from
    unique_orders
    inner join customer on unique_orders.cust_code = customer.cust_code
group by
    customer.cust_code
order by
    CNT desc,
    CODE desc
;