select 
cu.CUST_CODE as "CODE",
cu.CUST_NAME as "NAME",
count(*) as "CNT"
from CUSTOMER as cu
inner join 
(
select * from ORDERS
group by ORDER_DATE, CUST_CODE

)

 as od on od.CUST_CODE = cu.CUST_CODE
 where od.ORDER_DATE between '2023-07-01' and '2023-07-31'
group by cu.CUST_CODE, cu.CUST_NAME

order by CNT desc, CODE desc