user: ### NOW ANSWER:
Question: Who was Lieutenant Governor to the governor that left office on January 14, 1929?
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" = 'January 14, 1929';