WITH A AS(
SELECT ORDER_DATE,
ORDERS.CUST_CODE AS CODE,
CUSTOMER.CUST_NAME AS NAME
FROM ORDERS
JOIN CUSTOMER
ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
WHERE ORDER_DATE BETWEEN "2023-07-01" AND "2023-07-31" 
GROUP BY ORDERS.CUST_CODE,ORDER_DATE
ORDER BY ORDER_DATE DESC,ORDERS.CUST_CODE)

SELECT CODE,NAME,COUNT(*) AS CNT
FROM A
GROUP BY CODE,NAME
ORDER BY CNT DESC,CODE DESC;