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