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