select CUST_CODE as CODE, CUST_NAME as NAME, count(*) as CNT
from (select distinct CUST_CODE,CUST_NAME,ORDER_DATE
from ORDERS
left join CUSTOMER
using (CUST_CODE)
where  "2023-07-01" <= ORDER_DATE and ORDER_DATE <= "2023-07-31")
group by CUST_CODE, CUST_NAME
order by CNT desc, CODE desc