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