with
    --削除しないデータを抽出
    sub as (
        select
            ITEM.ITEM_CODE as ITEM_CODE
        from
            ITEM
            inner join STOCK
                on ITEM.ITEM_CODE = STOCK.ITEM_CODE
        where
            STOCK.LAST_DELIVERY_DATE > '2022/12/1'
            or STOCK.ACTUAL_AMT <> 0
            or ITEM.STOCK_MANAGEMENT_TYPE <> 1
        )
    
    --削除用（念のため、delete文の前に準備）
    ,sub2 as (
        select
            ITEM.ITEM_CODE as ITEM_CODE
        from 
            ITEM
        where
            NOT EXISTS(
                select * from sub
                where ITEM.ITEM_CODE = sub.ITEM_CODE)
        )
--select * from sub2

delete
from ITEM 
where ITEM_CODE in (
    select ITEM_CODE
    from sub2
    );
--select * from ITEM