SELECT o.CUST_CODE AS CODE,CUST_NAME AS NAME,COUNT(*) AS CNT
FROM ORDERS o
LEFT JOIN CUSTOMER c
ON o.CUST_CODE=c.CUST_CODE
WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY o.CUST_CODE
ORDER BY CNT DESC, CODE DESC