with tmp as(
select 
    o.CUST_CODE as CODE
    ,CUST_NAME as NAME
    ,date(ORDER_DATE) as target_date
    -- ,substr(date(ORDER_DATE),6,2) as target_month
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 1,3
)
select 
    CODE
    ,NAME
    ,count(*) as CNT
from tmp
group by CODE
order by 3 desc, 1 desc
;