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