CREATE TABLE table_50943 ("Senator" CLOB, "Party" CLOB, "District" FLOAT, "Home Town" CLOB, "Took Office" FLOAT)

Which Took Office has a District of 29?
SELECT AVG("Took Office") FROM table_50943 WHERE "District" = '29'
SELECT AVG("Took Office") FROM "table_50943" WHERE "District" = '29'