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