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