select cu.CUST_CODE        CODE
     , CUST_NAME           NAME
     , count(distinct o.ORDER_DATE) CNT

from orders o
     inner join customer cu on o.cust_code = cu.cust_code
where ORDER_DATE between '2023-07-01' and '2023-07-31'

group by cu.cust_code, CUST_NAME
order by 3 desc, 1 desc