with a  as(
select o.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 DATE(ORDER_DATE)>=2023/07/01
    or DATE(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