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 BETWEEN '2023-07-01' AND '2023-07-31' 

GROUP BY
    ORDERS.CUST_CODE
    
ORDER BY
    CNT  DESC,CODE  DESC;