select o.cust_code as CODE,
  cust_name as name,
  count(distinct order_date) as CNT
from orders as o
inner join customer c on c.cust_code = o.cust_code
where order_date between '2023-07-01' and '2023-07-31'
group by 1
order by 3 desc, 1 desc