select
	o.CUST_CODE AS CODE,
	c.CUST_NAME AS NAME,
	
	COUNT(DISTINCT o.ORDER_DATE)AS CNT
FROM
	ORDERS AS o
INNER JOIN CUSTOMER AS c
ON c.CUST_CODE=O.CUST_CODE
WHERE o.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31' 
GROUP BY o.CUST_CODE,c.CUST_NAME
ORDER BY
    CNT DESC, CODE DESC;