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