select ORDERS.CUST_CODE as 'CODE',
CUSTOMER.CUST_NAME as 'NAME',
count(Distinct ORDERS.ORDER_DATE) as 'CNT'
from ORDERS
inner join CUSTOMER
on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
where ORDERS.ORDER_DATE >= '2023-07-01' and ORDERS.ORDER_DATE <= '2023-07-31'
group by CODE, NAME
order by CNT DESC,CODE DESC