WITH DIST_ORDERS(ORD_CUST,ORDER_DATE) AS (
    SELECT DISTINCT CUST_CODE,ORDER_DATE
    FROM ORDERS
    WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
)

SELECT ORD_CUST AS CODE,CUST_NAME AS NAME,COUNT(*) AS CNT
FROM DIST_ORDERS JOIN CUSTOMER ON(ORD_CUST = CUST_CODE)
GROUP BY CUST_CODE
ORDER BY CNT DESC,ORD_CUST DESC