select
    c.cust_code as CUST_CODE,
    c.cust_name as CUST_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, CUST_CODE desc;