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 ITEM_CODE IN(
                    SELECT ITEM_CODE
                    FROM STOCK
                    GROUP BY ITEM_CODE
                    HAVING MAX(DATE(LAST_DELIVERY_DATE)) <= DATE('2023-06-01','-6 months')
                        AND SUM(ACTUAL_AMT) = 0
                )
        )
    )
;
SELECT ITEM_CODE FROM ITEM ORDER BY ITEM_CODE;