with
    A as (
        select
            *
        from
            ORDERS join CUSTOMER using(CUST_CODE)
        group by
            ORDER_DATE,
            CUST_CODE
    )

select
    CUST_CODE as 'CODE',
    CUST_NAME as 'NAME',
    COUNT(CUST_CODE) as 'CNT'
from
    A
where
    ORDER_DATE between '2023-07-01' and '2023-07-31'
group by
    CUST_CODE
order by
    CNT desc,
    CODE desc
;