select orders.CUST_CODE AS CODE, CUSTOMER.CUST_NAME as NAME,
COUNT(distinct orders.order_date) as CNT 
from orders
inner join CUSTOMER on orders.CUST_CODE = CUSTOMER.CUST_CODE
where orders.order_date between '2023-07-01' and '2023-07-31'
group by CUSTOMER.CUST_CODE, CUSTOMER.CUST_NAME
order by CNT desc, CUSTOMER.CUST_CODE desc