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