with tmp as(
select CUST_CODE as CODE,
DATE(ORDER_DATE) as ORDERD
from ORDERS
where ORDER_DATE between "2023-07-01" and "2023-07-31"
group BY 1,2
)
select t.CODE as CODE,
CUST_NAME as NAME,
COUNT(ORDERD) as CNT
from tmp t left join CUSTOMER on t.CODE = CUSTOMER.CUST_CODE
group by CODE
order by CNT desc, CODE desc