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