DELETE FROM
        ITEM
    WHERE
        -- 在庫管理する商品のみ対象
        STOCK_MANAGEMENT_TYPE = 1
    AND ITEM_CODE NOT IN
        (
            SELECT
                ITEM_CODE
                FROM
                    STOCK
                WHERE
                    LAST_DELIVERY_DATE > DATE('2023-06-01', '-6 month')
                AND ACTUAL_AMT > 0
        )
;