SELECT
	O.CUST_CODE AS CODE,
	C.CUST_NAME AS NAME,
	COUNT(O.ORDER_DATE) AS CNT
FROM
	( SELECT DISTINCT
	      CUST_CODE,
	      ORDER_DATE
	  FROM
	      ORDERS
	  WHERE
	      ORDER_DATE >= '2023-07-01' 
	  AND ORDER_DATE <  '2023-08-01'
	) O
	INNER JOIN CUSTOMER C
	ON O.CUST_CODE = C.CUST_CODE
GROUP BY
    CODE, NAME
ORDER BY
	CNT DESC,
	CODE DESC
;