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