with a  as(
select o.ORDER_DATE as ORDER_DATE, c.CUST_CODE, c.CUST_NAME from ORDERS o
left join CUSTOMER c
on o.CUST_CODE = c.CUST_CODE
where o.ORDER_DATE>='2023-07-01'
    and o.ORDER_DATE<='2023-07-31'
), b as(
select distinct ORDER_DATE, CUST_CODE, CUST_NAME
from a

)
select CUST_CODE as CODE, CUST_NAME as NAME, count(*) as CNT
from b
group by CUST_CODE, CUST_NAME
order by CNT desc, CODE desc