select b.CUST_CODE as CODE ,b.CUST_NAME as NAME,COUNT(b.CUST_CODE) CNT
from 
(select ORDER_DATE,CUST_CODE
from ORDERS
where ORDER_DATE>=date('2023-07-01') and ORDER_DATE<=date('2023-07-31') 
group by ORDER_DATE,CUST_CODE
) a,
CUSTOMER b
where  a.CUST_CODE=b.CUST_CODE
group by a.CUST_CODE
order by CNT DESC,CODE DESC