select CODE,NAME,count(code) as CNT 
from (
select orders.cust_code as CODE,cust_name as NAME,order_date 
from orders 
inner join customer 
on orders.cust_code=customer.cust_code 
where order_date between '2023-07-01' and '2023-07-31' 
group by orders.cust_code,order_date
) 
group by code 
order by cnt desc,code desc;