select
    c.cust_code as CODE,
    c.cust_name as NAME,
    count(distinct o.order_date) as CNT
from customer c join orders o using(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;