select C.CUST_CODE as CODE, CUST_NAME as NAME, count(ORDER_NO) as CNT
from CUSTOMER as C
inner join ORDERS as O
on C.CUST_CODE = O.CUST_CODE
where ORDER_DATE between '2023-07-01' and '2023-07-31'
group by CUST_NAME
order by CNT desc, CODE desc