select
O.CUST_CODE AS CODE,
C.CUST_NAME AS NAME,
COUNT(O.ORDER_NO) AS CNT
FROM
ORDERS AS O
LEFT JOIN CUSTOMER AS C
WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY C.CUST_CODE
ORDER BY CNT DESC,CODE DESC;