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