select 
ORDERS.CUST_CODE   as CODE,
CUSTOMER.CUST_NAME as NAME,
COUNT(ORDERS.ORDER_NO)    as CNT
from ORDERS
inner join CUSTOMER
on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
where ORDERS.ORDER_DATE between '2023-07-01' and '2023-07-31'
order by CNT DESC,
CODE DESC;