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