DELETE FROM ITEM
    WHERE ITEM_CODE NOT IN(
        SELECT ITEM_CODE
            FROM STOCK)
        AND ITEM_CODE IN(
        SELECT ITEM_CODE
            FROM STOCK
            WHERE (SELECT MAX(LAST_DELIVERY_DATE) FROM STOCK GROUP BY ITEM_CODE) IN(DATE('2023-06-01', '-6 months'),'2023-06-01')
            AND ACTUAL_AMT = 0)
        AND STOCK_MANAGEMENT_TYPE = 1