SELECT
    CODE
    ,(select cust_name from customer where customer.cust_code = CODE) as NAME
    ,CNT
FROM
    (
    SELECT
        cust_code AS CODE
        ,COUNT(order_date) AS CNT
    FROM
        (
            SELECT
                DISTINCT
                cust_code
                ,order_date
            FROM
                orders
            where
                order_date between date('2023-07-01') and date('2023-07-31')
        )
    GROUP BY 
        cust_code
    )
order by
    cnt desc
    ,code desc