Select ORDERS.CUST_CODE as CODE,
CUSTOMER.CUST_NAME as NAME,
COUNT(ORDERS.CUST_CODE) as CNT
from ORDERS
Join CUSTOMER
on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
where ORDERS.ORDER_DATE between 2023-07-01 and 2023-07-31
group by CODE, ORDERS.ORDER_DATE
order by CNT DESC, CODE DESC;