select distinct
C.CUST_CODE CODE,
C.CUST_NAME NAME,
count(ORDER_DATE) CNT

from ORDERS O inner join CUSTOMER C on (O.CUST_CODE = C.CUST_CODE)

where ORDER_DATE between '2023-07-01' and '2023-07-31'

group by CODE

order by CNT desc,
CODE desc