select o.CUST_CODE as 'CODE', c.CUST_NAME as 'NAME', 
count(distinct(ORDER_DATE)) as 'CNT'
from ORDERS o 
inner join CUSTOMER 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;