SELECT A.CUST_CODE AS CODE,B.CUST_NAME AS NANME,COUNT(*) AS CNT
FROM 
(
SELECT ORDER_DATE,CUST_CODE
FROM ORDERS
GROUP BY ORDER_DATE,CUST_CODE
) AS A
INNER JOIN CUSTOMER AS B
ON A.CUST_CODE = B.CUST_CODE
WHERE A.ORDER_DATE >= '2023-07-01' AND A.ORDER_DATE <= '2023-07-31'
GROUP BY A.CUST_CODE,B.CUST_NAME
ORDER BY CNT DESC,CODE ASC