SELECT C.CUST_CODE AS CODE, C.CUST_NAME AS NAME, COUNT(O.ORDER_DATE) AS CNT
FROM CUSTOMER C JOIN ORDERS O
WHERE C.CUST_CODE = O.CUST_CODE
AND O.ORDER_DATE BETWEEN '2023-07-1' AND '2023-07-31'
GROUP BY C.CUST_CODE,C.CUST_NAME
ORDER BY CNT DESC, CODE DESC