DELETE
FROM ITEM
WHERE
NOT EXISTS (
    SELECT *
    FROM STOCK S
    WHERE S.ITEM_CODE = ITEM_CODE
    AND STOCK_MANAGEMENT_TYPE = 1
)
OR
EXISTS (
    SELECT *
    FROM STOCK S
    WHERE S.ITEM_CODE = ITEM_CODE
    AND S.LAST_DELIVERY_DATE IS NOT NULL
    AND S.LAST_DELIVERY_DATE >= DATE('2023-06-01', '-6 month')
    AND S.ACTUAL_AMT = 0
    AND STOCK_MANAGEMENT_TYPE = 1
);