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