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