select distinct
c.CUST_CODE as 'CODE',
c.CUST_NAME as 'NAME',
count(o.CUST_CODE) as 'CNT'
from ORDERS o, CUSTOMER c
where o.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
and o.CUST_CODE = c.CUST_CODE
group BY o.CUST_CODE
order by CNT desc, CODE desc
;