with a  as(
select DATE(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
), b as(
select distinct ORDER_DATE, CUST_CODE, CUST_NAME
from a
where ORDER_DATE>=2023/07/01
    and ORDER_DATE<=2023/07/31
)
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