CREATE TABLE table_76835 ("Name" CLOB, "Took Office" CLOB, "Left Office" CLOB, "President" CLOB, "Party" CLOB)

What is Left Office, when Party is Vacant (1999-2001)?
SELECT "Left Office" FROM table_76835 WHERE "Party" = 'vacant (1999-2001)'
SELECT "Left Office" FROM "table_76835" WHERE "Party" = 'vacant (1999-2001)'