DELETE FROM ITEM
WHERE ITEM_CODE NOT IN (SELECT ITEM_CODE FROM STOCK)
OR (
    STOCK_MANAGEMENT_TYPE = 1 
    AND ITEM_CODE IN (
        SELECT ITEM_CODE FROM STOCK
        WHERE LAST_DELIVERY_DATE <= date('2023-06-01', '-6 month')
        AND ACTUAL_AMT = 0
    )
);

SELECT * FROM ITEM