with a as
(
select distinct CUST_CODE,ORDER_DATE
from ORDERS
where ORDER_DATE between '2023-07-01' and '2023-07-31'
)
select
CUSTOMER.CUST_CODE as CODE,
CUSTOMER.CUST_NAME as NAME,
count(*) as CNT
from a,CUSTOMER
where a.CUST_CODE =CUSTOMER.CUST_CODE
group by CUSTOMER.CUST_CODE,CUSTOMER.CUST_NAME
order by 3 desc, 1 desc