WITH t AS(
    SELECT
        CUST_CODE AS CODE
        , CUST_NAME AS NAME
        , COUNT() AS cnt_date
        , ORDER_DATE
    FROM
        ORDERS
        LEFT OUTER JOIN CUSTOMER USING(CUST_CODE)
    WHERE
        ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
    GROUP BY CUST_CODE, ORDER_DATE
)
SELECT DISTINCT
    CODE
    , NAME
    , COUNT() OVER (PARTITION BY CODE) AS CNT
FROM
    t
ORDER BY 3 DESC, 1 DESC;