DELETE FROM STOCK
WHERE
    ITEM_CODE NOT IN (
        SELECT ITEM_CODE
        FROM ITEM
    )
    OR (
        ITEM_CODE IN (
            SELECT ITEM_CODE
            FROM ITEM
            WHERE STOCK_MANAGEMENT_TYPE = 1
        )
        AND (
            LAST_DELIVERY_DATE IS NULL
            OR strftime('%Y-%m-%d', LAST_DELIVERY_DATE) <= date('2023-06-01', '-6 months')
        )
        AND ACTUAL_AMT = 0
    );