select
C.CUST_CODE as CODE,
C.CUST_NAME as NAME,
count(distinct O.ORDER_DATE) as CNT
from ORDERS O, CUSTOMER C
where O.CUST_CODE = C.CUST_CODE
group by C.CUST_CODE
having O.ORDER_DATE between '2023-07-01' and '2023-07-31'
order by CNT desc, CODE asc