WITH orderCntdate AS(
	SELECT
		CUST_CODE
		,COUNT(DISTINCT ORDER_DATE) AS CNT
	FROM ORDERS
	WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
	GROUP BY 1
)
SELECT
	t1.CUST_CODE AS CODE
	,t2.CUST_NAME AS NAME
	,t1.CNT
FROM orderCntdate AS t1
INNER JOIN CUSTOMER AS t2
	ON t1.CUST_CODE = t2.CUST_CODE
ORDER BY
	t1.CNT DESC
	,CODE DESC