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