select C.CUST_CODE as CODE, CUST_NAME as NAME, count(DISTINCT O.ORDER_DATE) as CNT
from ORDERS as O
 inner join CUSTOMER as C on C.CUST_CODE = O.CUST_CODE
where O.ORDER_DATE between '2023-07-01' AND '2023-07-31' 
group by O.CUST_CODE, C.CUST_NAME
order by CNT desc, CODE desc