CREATE TABLE table_name_8 (took_office NUMBER, district VARCHAR2)

Which Took Office has a District of 29?
SELECT AVG(took_office) FROM table_name_8 WHERE district = 29
SELECT AVG("took_office") FROM "table_name_8" WHERE "district" = 29