select
    TBL1.CUST_CODE as CODE,
    TBL2.CUST_NAME as NAME,
    count(TBL1.CUST_CODE) as CNT
from
    (
    select distinct
        CUST_CODE,
        ORDER_DATE
    from
        ORDERS
    ) as TBL1
left outer join CUSTOMER as TBL2 on TBL1.CUST_CODE = TBL2.CUST_CODE 
where
    ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
group by
    TBL1.CUST_CODE,TBL2.CUST_NAME
order by
    3 desc,1 desc