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