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 in (select item_code from t where z <= "2022-12-01" and y = 0)
)