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