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