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 t where z <= "2023-01-01" and y = 0)