SELECT A.CUST_CODE AS CODE
      ,B.CUST_NAME AS NAME
      ,COUNT(*) AS CNT
FROM (
    SELECT X.CUST_CODE
          ,X.ORDER_DATE
    FROM ORDERS X
    WHERE REPLACE(X.ORDER_DATE, '-', '') >= '20230701'
    AND REPLACE(X.ORDER_DATE, '-', '') <= '20230731'
    GROUP BY X.CUST_CODE, X.ORDER_DATE
) A
INNER JOIN CUSTOMER B
ON A.CUST_CODE = B.CUST_CODE
GROUP BY A.CUST_CODE
ORDER BY CNT DESC, CODE DESC