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;