with non_target as(
    select
        ITEM_CODE
        , max(coalesce(LAST_DELIVERY_DATE, '2023-06-01')) as MAX_LAST_DELIVERY_DATE
        , sum(ACTUAL_AMT) as SUM_ACTUAL_AMT
    from
        STOCK
    group by
        ITEM_CODE
    having
        MAX_LAST_DELIVERY_DATE > '2022-12-01'
        and SUM_ACTUAL_AMT > 0
)
delete from
    ITEM
where
    ITEM_CODE not in (select ITEM_CODE from non_target)
    and STOCK_MANAGEMENT_TYPE = 1
;