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: A qual parte o congressista Dick Clark pertence?
 ###Tabelas: CREATE TABLE earliest_serving_senators_currently_living (earliest_serving_senators_currently_living_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Senator VARCHAR, Date of birth VARCHAR, Entered Senate VARCHAR, Left Senate VARCHAR, State served VARCHAR, Party VARCHAR, Time since entry VARCHAR) CREATE TABLE fares (fares_id AUTO_INCREMENT PRIMARY KEY, Type of Fare VARCHAR, Cash Fare VARCHAR, Day Pass VARCHAR, 31-Day Pass VARCHAR, Monthly Pass VARCHAR) CREATE TABLE record_vs._big_12_opponents (record_vs._big_12_opponents_id AUTO_INCREMENT PRIMARY KEY, Missouri vs. VARCHAR, Overall Record VARCHAR, at Columbia VARCHAR, at Opponents Venue VARCHAR, at Neutral Site VARCHAR, Last 5 Meetings VARCHAR, Last 10 Meetings VARCHAR, Current Streak VARCHAR, During Time in Big 12 VARCHAR) CREATE TABLE doubles_20_10-10 (doubles_20_10-10_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score VARCHAR) CREATE TABLE 2006_2007 (2006_2007_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Site VARCHAR, Sport VARCHAR, Winning team VARCHAR, Series VARCHAR)  
SELECT Party FROM earliest_serving_senators_currently_living WHERE Senator = Dick Clark