with tbl as (
    select distinct ORDER_DATE,CUST_CODE
    from ORDERS
)


select
    a.CUST_CODE as CODE
    ,b.CUST_NAME as NAME
    ,count(*) as CNT
from tbl a
    left join CUSTOMER b
    on a.CUST_CODE = b.CUST_CODE
where
    a.ORDER_DATE between '2023-07-01' and '2023-07-31'
group by
    CODE,NAME
order by
    CNT desc
    ,CODE desc