with t as (
    select item_code, max(coalesce(last_delivery_date, "2023-12-01")) as z, sum(actual_amt) as y
    from stock
    group by item_code
)
delete 
from item 
where stock_management_type=1 
and (item_code not in (select item_code from stock) or
item_code not in (select item_code from t where z < "2023-01-01" and y = 0)
)