with cnt_2 as (
    select c.cust_code,c.cust_name, o.order_date
    from orders as o
    left outer join customer as c
    on o.cust_code = c.cust_code
    where order_date between "2023-07-01" and "2023-07-31"
    group by c.cust_code, order_date
    order by order_date
    )

select cust_code as CODE, cust_name as NAME, count(cust_code) as CNT
from cnt_2
group by cust_code
order by CNT desc,CODE desc;