with t1 as (
select distinct ORDER_DATE, CUST_CODE
from ORDERS
where ORDER_DATE LIKE '2023-07%'
)
select c.CUST_CODE as CODE, c.CUST_NAME as NAME, COUNT(t1.ORDER_DATE) as CNT
from CUSTOMER as c
left join t1
on c.CUST_CODE = t1.CUST_CODE
group by 1, 2
having CNT != 0
order by CNT desc, CODE desc