delete from ITEM
where STOCK_MANAGEMENT_TYPE = 1 and ITEM_CODE in

(
select distinct ITEM_CODE
from STOCK
where LAST_DELIVERY_DATE >= "2023-01-02" or ACTUAL_AMT > 0)