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