select 
ORDERS.CUST_CODE as 'CODE',
CUSTOMER.CUST_NAME as 'NAME',
COUNT(ORDERS.CUST_CODE) as 'CNT'
from ORDERS
left join CUSTOMER
on ORDERS.CUST_CODE  = CUSTOMER.CUST_CODE 
where ORDER_DATE >= '2023-07-01' and ORDER_DATE <= '2023-07-31'
group by ORDERS.CUST_CODE 
order by CNT desc ,CODE desc