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) <= DATE('2023-06-01', '-6 months')
            AND ACTUAL_AMT = 0
            GROUP BY ITEM_CODE)
        AND STOCK_MANAGEMENT_TYPE = 1