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