user: ### NOW ANSWER:
Question: Who was lieutenant governor to the governor that left office on October 16, 2000?
Columns: ['Governor', 'Took office', 'Left office', 'Party', 'Lieutenant Governor', 'Terms']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Alexander McNair', 'September 18, 1820', 'November 15, 1824', 'Democratic-Republican', 'William Henry Ashley', '1']
SQL:

assistant: SELECT "Lieutenant Governor" FROM "Table" WHERE "Left office" = 'October 16, 2000';