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