select
distinct
C.CUST_CODE as CODE,
C.CUST_NAME as NAME,
count(*) as CNT
from ORDERS O, CUSTOMER C
where O.CUST_CODE = C.CUST_CODE
group by C.CUST_CODE
having O.ORDER_DATE between '2023-07-01' and '2023-07-31'
order by CNT desc, CODE asc;