select
    c.CUST_CODE         as CODE,
    c.CUST_NAME         as NAME,
    count(o.CUST_CODE)  as CNT
from (
    select distinct
        ORDER_DATE,
        CUST_CODE
    from
        ORDERS
) as o
join
    CUSTOMER c
on
    o.CUST_CODE = c.CUST_CODE
where
    o.ORDER_DATE between "2023-07-01" and "2023-07-31"
group by
    c.CUST_CODE
order by
    CNT     desc,
    CODE    desc