SELECT
 C.CUST_CODE as CODE,
 C.CUST_NAME as NAME,
 COUNT(ORDER_NO) as CNT
FROM CUSTOMER as C
INNER JOIN ORDERS as O
ON C.CUST_CODE = O.CUST_CODE
WHERE O.ORDER_DATE>='2023-07-01' and O.ORDER_DATE<='2023-07-31'
GROUP BY C.CUST_CODE,C.CUST_NAME
ORDER BY CNT desc,CODE desc