CREATE TABLE table_name_42 (took_office INT, left_office VARCHAR)

What is the Took Office Date of the Presidency that Left Office Incumbent?
SELECT SUM(took_office) FROM table_name_42 WHERE left_office = "incumbent"
SELECT SUM("took_office") FROM "table_name_42" WHERE "incumbent" = "left_office"