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