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