WITH temp AS(SELECT ORDER_DATE,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_DATE
)
SELECT CODE,NAME,CNT 
FROM TEMP
ORDER BY CNT DESC, CODE DESC