SELECT
    c.CUST_CODE as CODE
    , c.CUST_NAME as NAME
    , COUNT(*) as CNT
FROM
    ORDERS o
JOIN
    CUSTOMER c
        ON o.CUST_CODE = c.CUST_CODE
WHERE
    ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY
    c.CUST_CODE
ORDER BY
    CNT desc, CODE desc