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