delete from ITEM
where
    not exists(
        select  *
        from    STOCK
        where   ITEM.ITEM_CODE = STOCK.ITEM_CODE
    )
or  (select LAST_DELIVERY_DATE from STOCK where ACTUAL_AMT = 0) < "2023-01-01"