with tmp as(
select CUST_CODE as CODE,
DATE(ORDER_DATE) as ORDERD
from ORDERS
where DATE(ORDER_DATE) between "2023-07-01" and "2023-07-31"
)
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