delete from item
where item_code in (
select
    i.item_code
from
    item i left join stock s
    on i.item_code = s.item_code
where
    s.last_delivery_date <= '2022-12-31'
)
;
select * from item;