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