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