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