WITH UNIQUE_ORDERS AS(
    SELECT ORDER_DATE, CUST_CODE
    FROM ORDERS
    GROUP BY ORDER_DATE, CUST_CODE
)
SELECT UNIQUE_ORDERS.CUST_CODE AS CODE, CUSTOMER.CUST_NAME AS NAME, COUNT(UNIQUE_ORDERS.CUST_CODE) AS CNT
FROM UNIQUE_ORDERS
JOIN CUSTOMER ON UNIQUE_ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
WHERE UNIQUE_ORDERS.ORDER_DATE>='2023-07-01' AND UNIQUE_ORDERS.ORDER_DATE<='2023-07-31'
GROUP BY CODE
ORDER BY CNT DESC, CODE DESC