select
    c.cust_code as CODE,
    c.cust_name as NAME,
    count(o.order_no) as CNT
from
    (select distinct
    order_no, order_date, cust_code
from
    orders
group by
    order_date,
    cust_code
) as o
inner join
    customer as c
on
    o.cust_code = c.cust_code
where
    o.order_date >= "2023-07-01"
and o.order_date <= "2023-07-31"
group by
    c.cust_name
order by
    CNT desc,
    CODE desc