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 CUSTOMER.USER_UPDATE_DATETIME>='2023-07-01' AND CUSTOMER.USER_UPDATE_DATETIME<='2023-07-31'
GROUP BY CODE
ORDER BY CNT DESC, CODE DESC