Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual Tomou Posse tem um Distrito de 29?
 ###Tabelas: CREATE TABLE mano_parejas (mano_parejas_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Champion VARCHAR, Subchampion VARCHAR, Scoreboard VARCHAR, Fronton VARCHAR) CREATE TABLE popular_languages_used_for_data_exchange (popular_languages_used_for_data_exchange_id AUTO_INCREMENT PRIMARY KEY, Schemas VARCHAR, Flexible VARCHAR, Semantic verification VARCHAR, Dictionary VARCHAR, Information Model VARCHAR, Synonyms and homonyms VARCHAR, Dialecting VARCHAR, Web standard VARCHAR, Transformations VARCHAR, Lightweight VARCHAR, Human readable VARCHAR) CREATE TABLE senate (senate_id AUTO_INCREMENT PRIMARY KEY, Senator VARCHAR, Party VARCHAR, District INT, Home Town VARCHAR, Took Office INT) CREATE TABLE michigan_single-game_reception_yardage (michigan_single-game_reception_yardage_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Rec. INT, Yards INT, Average INT, s Touchdown INT, Year INT, Opponent VARCHAR) CREATE TABLE team_distribution (team_distribution_id AUTO_INCREMENT PRIMARY KEY, Round VARCHAR, Clubs remaining INT, Clubs involved INT, Winners from previous round VARCHAR, New entries this round VARCHAR, Leagues entering at this round VARCHAR)  
SELECT AVG Took Office FROM senate WHERE District = 29