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