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