with a as (select 
ORDER_DATE, CUST_CODE
from orders where order_date between '2023-07-01' and '2023-07-31'
group by ORDER_DATE, CUST_CODE
)
select a.CUST_CODE as CODE, c.CUST_NAME as NAME, count(1) as CNT from a join customer c on a.CUST_CODE = c.CUST_CODE group by a.CUST_CODE
order by CNT desc, CODE desc