SELECT
	A.CUST_CODE AS CODE
,	B.CUST_NAME AS NAME
,	COUNT(DISTINCT A.ORDER_DATE) AS CNT
FROM
	ORDERS A
,	CUSTOMER B
WHERE
	A.CUST_CODE = B.CUST_CODE
AND	A.ORDER_DATE >= '2023-07-01'
AND	A.ORDER_DATE <= '2023-07-31'
ORDER BY
	CNT DESC
,	CODE DESC