select CUSTOMER.CUST_CODE as CODE, CUSTOMER.CUST_NAME as NAME, COUNT(DISTINCT ORDER_DATE) as CNT from ORDERS
join CUSTOMER on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY CUSTOMER.CUST_NAME
ORDER BY CNT DESC, CODE DESC
;