SELECT CUST_CODE AS CODE,CUST_NAME AS NAME,COUNT(*) AS CNT
FROM ORDERS
WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY CUST_CODE
ORDER BY CNT DESC, CODE DESC