SELECT
	OD.CUST_CODE AS CODE
	, CT.CUST_NAME AS NAME
	, COUNT(DISTINCT OD.ORDER_DATE) AS CNT
FROM ORDERS AS OD
	INNER JOIN CUSTOMER AS CT
		ON CT.CUST_CODE = OD.CUST_CODE
WHERE OD.ORDER_DATE BETWEEN '2023-7-1' AND '2023-7-31'
GROUP BY OD.CUST_CODE 
    	, CT.CUST_NAME
ORDER BY CNT DESC
		, CODE DESC;