WITH grep AS(
    SELECT
        *
    FROM
        ITEM
    WHERE
        STOCK_MANAGEMENT_TYPE = '1'
),
nul AS(
    SELECT
        ITEM_CODE
    FROM
        grep
    WHERE
        NOT EXISTS(
            SELECT
                *
            FROM
                STOCK
            WHERE
                grep.ITEM_CODE = STOCK.ITEM_CODE
        )
),
grouping AS(
    SELECT
        grep.ITEM_CODE,
        SUM(ACTUAL_AMT) amt,
        MIN(LAST_DELIVERY_DATE) ldate
    FROM
        STOCK
        INNER JOIN grep ON grep.ITEM_CODE = STOCK.ITEM_CODE
    GROUP BY
        grep.ITEM_CODE
),
old AS (
    SELECT
        *
    FROM
        grouping
    WHERE
        ldate IS NOT NULL
        AND ldate < '2022-12-01'
        AND amt = 0
),
del AS(
    SELECT
        *
    FROM
        nul
        CROSS JOIN old
)
DELETE FROM
    ITEM
WHERE
    ITEM_CODE = (
        SELECT
            ITEM_CODE
        FROM
            del
    )