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