What is Left Office, when Party is Vacant (1999-2001)?
CREATE TABLE table_76835 (
    "Name" text,
    "Took Office" text,
    "Left Office" text,
    "President" text,
    "Party" text
)
SELECT "Left Office" FROM table_76835 WHERE "Party" = 'vacant (1999-2001)'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is Left Office, when Party is Vacant (1999-2001)? ### Input: CREATE TABLE table_76835 (
    "Name" text,
    "Took Office" text,
    "Left Office" text,
    "President" text,
    "Party" text
) ### Response: SELECT "Left Office" FROM table_76835 WHERE "Party" = 'vacant (1999-2001)'