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