with NO_ITEM_CODE as (
select
    I.ITEM_CODE
from
    ITEM I
    left outer join 
        STOCK S 
        on I.ITEM_CODE=S.ITEM_CODE
where
    S.ITEM_CODE is null
)
,TARGET_ITEM_CODE as (
select
    I.ITEM_CODE 
from
    ITEM I 
    left outer join
    (select
        ITEM_CODE
        ,sum(ACTUAL_AMT) as ACTUAL_AMT
        ,max(LAST_DELIVERY_DATE) as LAST_DELIVERY_DATE
    from STOCK
    group by 1) S 
        on I.ITEM_CODE=S.ITEM_CODE
where
    S.ACTUAL_AMT=0
    and LAST_DELIVERY_DATE<='2022-12-01'
)

delete 
from ITEM 
where
    STOCK_MANAGEMENT_TYPE='1'
    and (
    ITEM_CODE IN (select ITEM_CODE from NO_ITEM_CODE)
    or 
    ITEM_CODE IN (select ITEM_CODE from TARGET_ITEM_CODE)
    )