select
ORDERS.CUST_CODE as 'CODE',
CUSTOMER.CUST_NAME as 'NAME',
count(ORDER_DATE) as 'CNT'
from
ORDERS
left join
CUSTOMER on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
where
ORDERS.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
group by
CUSTOMER.CUST_NAME
order by
CNT desc,
CODE desc